Is there any way to override the default for DateTime?

[viseu]

Hello,
I have a table in SQL Server with a not null datetime named CreatedDateTime. If I apply the filter CreatedDateTime != it will throw an exception as the generated SQL will be .Where(__User => __User.CreatedDateTime != 01/01/0001 00:00:00) which that year is not supported in SQL Server.

Is there a way to globally set to use NULL instead of default(datetime) so that I can force __User.CreatedDateTime IS NOT NULL?

I can make it work with the work around below but I want to avoid repeating that code for different tables and columns:
mapper.AddMap("CreatedDateTime", u => (DateTime?)u.CreatedDateTime);

I understand that it does not make sense to apply a non null filter on a not nullable column, but the filter is available from the frontend by default on all columns.

Thank you!

[alirezanet]

Hi @viseu,
I don't think there is anyway to solve the issue if you don't want to make your CreatedDateTime property nullable.
I would suggest to simply change it to a nullable type since you expect null values.

[viseu]

Tks!