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

Question

This is my code

var finalResults = (from r in results.AsEnumerable()
                    where r.Field<DateTime>("PrintTime") is DBNull

where PrintTime is a column in my Sql Server 2008 r2 database, its type is datetime and it is nullable

I got this exception:

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

Could you help please?

Answer 1

DataRow.Field supports nullable types, so use DateTime? instead of DateTime:

var finalResults = from r in results.AsEnumerable()
                   let printTime = r.Field<DateTime?>("PrintTime")
                   where !printTime.HasValue
                   select r;