Setting SQL datetime to minimum using C# DateTime

Question

I have a datetime column in SQL Server. I believe the minimum it can be is some date in 1753 or something. My Entity Framework POCO representing the table contains a DateTime. I'd like to set the datetime in the database to the minimum it can be set to. What's the easiest way to do this?

Answer 1

That value can be retrieved using the following property;

SqlDateTime.MinValue

See http://msdn.microsoft.com/en-us/library/system.data.sqltypes.sqldatetime.minvalue.aspx for more details.