Solution to: "The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value" with Entity Framework when calling SaveChanges

Go into your EDMX file, select the field that is causing the error and set StoreGeneratedPattern to Computed.

Add the DatabaseGenerated attribute if you are using EF Code First:

1
2
[DatabaseGenerated(DatabaseGeneratedOption.Computed)]
public Nullable<System.DateTime> Created { get; set; }

Share