c# - Cannot cast DBNull.Value to type 'System.DateTime'. Please use a nullable type -

c# - Cannot cast DBNull.Value to type 'System.DateTime'. Please use a nullable type -

this code

var finalresults = (from r in results.asenumerable() r.field<datetime>("printtime") dbnull

where printtime column in sql server 2008 r2 database, type datetime , nullable

i got exception:

cannot cast dbnull.value type 'system.datetime'. please utilize nullable type.

could help please?

datarow.field supports nullable types, utilize datetime? instead of datetime:

var finalresults = r in results.asenumerable() allow printtime = r.field<datetime?>("printtime") !printtime.hasvalue select r;

c# sql .net sql-server-2008-r2