How to change EF6 to create Datetime fields as datetime2

Question

I am working with **EF6 Code-first", SQL-Server database.

I came across the following error, when saving an object with Datetime property.

The Conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value. The statement has been terminated.

Searching, I found that EF6 by default creates the Type properties Datetime of C#, like the guy datetime of Sql-Server.

I did some research to understand the difference, even created a question about it here in the stack datetime vs datetime2. which is the best?, in the colleague’s reply, he highlighted the suggestion in the microsoft documentation itself, indicating the use of datetime2. As mentioned below..

Use the data types time, date, datetime2 and datetimeoffset for the new job. These types are in accordance with the standard SQL. They are more portable. time, datetime2 and datetimeoffset provide more accuracy of seconds. datetimeoffset is time zone compatible for globally deployed applications. Source: https://docs.microsoft.com/pt-br/sql/t-sql/data-types/datetime-transact-sql

Based on that, I want to know how to get EF6 to use the datetime2, without having to configure the property property. Which would be as follows:

Property(m => m.Created)
        .HasColumnName("Created")
        .HasColumnType("datetime2")
        .IsRequired();

I want a global setup.

Answer 1

In my case, I defined this in the method OnModelCreating, adding this line:

modelBuilder.Properties<DateTime>().Configure(c => c.HasColumnType("datetime2"));

It was an answer to that question in the OR (I don’t accept it, but the one that helped me): https://stackoverflow.com/questions/15687408/how-to-switch-to-datetime2-in-enitity-framework-sql-server-2008-project

Answer 2

In his Context you can configure so that all type properties DateTime are datetime2. For that it is necessary to give one override the method OnModelCreating the code would look like this:

public class MyContext : DbContext
{
    public MyContext()
    {}

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {            
        modelBuilder.Properties<DateTime>()
            .Configure(p => p.HasColumnType("datetime2"));
    }
}