How to handle nullable DateTime in LINQ-to-SQL, where is the condition?

Question

I need to select a list of coupons that have not expired. I.e:

where Coupon.ExpiresOn > DateTimeUtc.Now

The problem is that Coupon.ExpiresOn is a null DateTime (DateTime?). The code above does not return coupons with zero values ​​in Coupon.ExpiresOn. How can I change it to return null values? Thank you for your help.

Answer 1

allow nulls in your place, for example:

where Coupon.ExpiresOn == null || Coupon.ExpiresOn> DateTimeUtc.Now

Answer 2

Add a statement or to your statement:

where !Coupon.ExpiresOn.HasValue || Coupon.ExpiresOn.Value > DateTimeUtc.Now