datetime2 in sql.

Accepted answer

@Rohan,

Now, EF Core maps the DateTime property to DateTime2 of sql server. So, keep it as is. There is no harm in it.

System.DateTime maps directly to SQL Server datetime2 and is the Microsoft recommended datatype for storage of a System.DateTime in SQL Server.

Also worth noting that a datetime2(7) takes one less byte of space than a datetime and offers increased precision.

Rohan4y ago

Any update on it.

Rohan4y ago

3 Replies