Entity Framework Code First use SQL Server datetime2 instead of datetime everywhere

Question

I know this can be accomplished using the Fluent API on a single property, but I want to have this automatically happen for everywhere I use a .NET DateTime in my model. Here's an example of doing a single property:

modelBuilder.Entity<T>() .Property(f => f.MyDateTimeProperty) .HasColumnType("datetime2");

But instead of only on this one property I want it to happen everywhere automatically. There is a fix for this in Model First by editing the T4 generation template so I know it can be done there but I need the same thing in Code First.

Colin · Accepted Answer · 2014-08-20 09:55:37Z

5

You want to use a Custom Code First Convention.

There's an example of exactly what you are trying to do here: http://msdn.microsoft.com/en-us/data/jj819164.aspx

answered Aug 20, 2014 at 9:55

Colin

22.7k17 gold badges111 silver badges211 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework Code First use SQL Server datetime2 instead of datetime everywhere

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related