The conversion of a datetime2 data type to a datetime data type resulted in an Out-of-range value. Causes of errors and solutions

Exception Description:

Data access with EF, the default value set in the database with GETDATE () is not assigned in the program.

An exception occurred.

This error in Baidu before I write this article there are not many solutions, Google wait until the following two useful pages:

Http://stackoverflow.com/questions/1331779/c-sharp-conversion-of-a-datetime2-data-type-to-a-datetime-data-type

http://stackoverflow.com/questions/4608734/ The-conversion-of-a-datetime2-data-type-to-a-datetime-data-type-resulted-in-an-o

Cause of the error:

Because in the range of datetime in. NET, it started in 0001-01-01

Scope of DATETIME2 (Transact-SQL): 0001-01-01 to 9999-12-31

DATETIME (Transact-SQL): January 1, 1753 to December 31, 9999

The conversion of a datetime2 data type to a datetime data type resulted in an Out-of-range value. Causes of errors and solutions