Entity framework date/time conversion for sqlserver

Question

I prefer working with DateTime.MinValue, even if I use SqlServer as backend.

Is it possible to make Entity Framework to convert from DateTime.MinValue to 1753-01-01 when saving entities and convert back to DateTime.MinValue when fetching them?

Edit: I do not want to use DateTime? (nullable value type)

You prefer DateTime.MinValue (and the SQL Server minimum datetime value) to null? Really? — Daniel Renshaw
– Daniel Renshaw, Commented Sep 1, 2010 at 14:51
Yes, Date comparsion is a tidier when comparing to MinValue than have to check for null everywhere. Same reason as why string.Empty exists. — jgauffin
– jgauffin, Commented Sep 23, 2010 at 13:36

Dave Brace · Accepted Answer · 2011-02-15 23:22:04Z

2

If SQL Server 2008 is an option, you could go with using datetime2 in your database which would allow you to store DateTime.MinValue.

answered Feb 15, 2011 at 23:22

Dave Brace

1,8092 gold badges16 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

jgauffin Over a year ago

Accepted the answer since no EF4 answers are avail. A datetype filter similar to IUserType in nhibernate would be preferable.

Collectives™ on Stack Overflow

Entity framework date/time conversion for sqlserver

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related