Server Error in '/' Application.

Cannot implicitly convert type 'System.DBNull' to 'System.DateTime'

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.CSharp.RuntimeBinder.RuntimeBinderException: Cannot implicitly convert type 'System.DBNull' to 'System.DateTime'

Source Error:


Line 6:      
Line 7:      var selectQueryString = "SELECT Min(Day) FROM MarketDay WHERE Day >= DateAdd(dd, -1, GetDate())";
Line 8:      DateTime  week  = db.QueryValue(selectQueryString);  
Line 9:         
Line 10:     selectQueryString = @"SELECT b.BoothNumber, LTrim(RTrim(v.Company)) + ' (' +  RTrim(v.FirstName) + ' ' + RTrim(v.LastName) + ')' as Vendor, v.Photo,

Source File: c:\ClientSites\redmondsaturdaymarket.org\httpdocs\WeekVendors.cshtml    Line: 8

Stack Trace:


[RuntimeBinderException: Cannot implicitly convert type 'System.DBNull' to 'System.DateTime']
   CallSite.Target(Closure , CallSite , Object ) +169
   System.Dynamic.UpdateDelegates.UpdateAndExecute1(CallSite site, T0 arg0) +662
   ASP._Page_WeekVendors_cshtml.Execute() in c:\ClientSites\redmondsaturdaymarket.org\httpdocs\WeekVendors.cshtml:8
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy() +255
   System.Web.WebPages.WebPage.ExecutePageHierarchy(IEnumerable`1 executors) +94
   System.Web.WebPages.WebPage.ExecutePageHierarchy() +183
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +108
   System.Web.WebPages.WebPageHttpHandler.ProcessRequestInternal(HttpContextBase httpContext) +144


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4700.0