Setting SQL datetime to minimum using C# DateTime

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?

  • SQL Server Trigger switching Insert,Delete,Update
  • How to create default instance after creating a named instance?
  • Multivalued parameter within T-SQL Query
  • Hierarchical structure, new columns, denormalization
  • Executing a stored procedure within a stored procedure
  • How can I improve this Mailing Address SQL Server SELECT Statement?
  • SQL query returns incorrect value in multi user environment
  • Get Excel sheet into temp table using a script
  • selecting the Row of table Except the First one
  • Combining multiple rows into one row and appending the columns depending on the number of rows
  • T-SQL - create partition function and scheme - SQL Server 2008
  • Saving PNG picture from SQL Server as BMP/JPG
  • One Solution collect form web for “Setting SQL datetime to minimum using C# DateTime”

    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.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.