[EntityFramework] Use SQL server time or field default value for DateTime type

DateTime type on SQL server if you set a default value, and you want to use the default value when EntityFramework adds a new row, you cannot assign a value to the DateTime field of the newly added entity.

However, if the newly added entity DateTime is not set, an error will appear as follows:

System.Data.Entity.Infrastructure.DbUpdateException -An error occurred while updating the entries. See the inner exception for details.
System.Data.Entity.Core.UpdateException -An error occurred while updating the entries. See the inner exception for details.
System.Data.SqlClient.SqlException -The conversion of a datetime2 data type to a datetime data type resulted in An Out-of-range value.
The statement has been terminated.

Solution:

Navigate to the Edmx file, select the field of the DateTime type, and in the Properties window, change Storegeneratepattern from None to Computed.

[EntityFramework] Use SQL server time or field defaults for DateTime types