The conversion from the datetime2 data type to the datetime data type generates a value out of the range ., Datetime2datetime

The conversion from the datetime2 data type to the datetime data type generates a value out of the range ., Datetime2datetime

EF exception: the conversion from datetime2 data type to datetime data type generates a value out of the range.

Scenario I encountered: The receiving time is of the string type, and an exception occurs during jsonserializer, which is converted to "0001/1/1 00:00:00". An exception occurs when SaveChanges is SaveChanges after EF Update, the field type in the database is DateTime.

Cause:

Specify fields and attributes of a specific data type of SQL Server for SqlParameter.

Namespace:System. Data
Assembly:System. Data (located in System. Data. dll)

Public enum SqlDbType

 

This has nothing to do with struct System. DateTime.

Reference: http://blog.csdn.net/zhruifei/article/details/50715528