Using C#, Linq to SQL, SQL Server, I have this:
MyTable has a column with a "datetime null" column.
DateTime? aDateTime;
var records = (from row in MyTable where row.StartDate == aDateTime);
And I noticed that the query does not do what I expected. Specifically, if aDateTime is null, it queries StartDate = null
rather than StartDate IS null
, which does not find records where the column value is null. Changing it to:
where aDateTime.HasValue ? (row.StartDate == aDateTime) : (row.StartDate == null)
works but is annoying. Is there a simpler solution to this problem?
I think Object.Equals(row.StartDate, aDateTime)
will do the trick.
There is lots about this on Google. For example, this post.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With