CODEWITHSUNDEEP
c#.netentity-frameworkef-code-firstdatetime2
Eric
Eric

Reputation: 6016

Is it possible to force all DateTime properties to be modeled as DateTime2?

In Entity Framework 6 Code First, is there a way to force all DateTime properties to be modeled as DateTime2?

I know that I can do 

.HasColumnType("datetime2")

on each individual DateTime property, but I'm wondering if there's a way to set it as a default for all DateTime properties.

Upvotes: 5

Views: 955

Answers (1)

Matt DeKrey
Matt DeKrey

Reputation: 11942

Yes.

In Entity Framework 6's Fluent API, you can update all DateTime properties using this one line:

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

Upvotes: 8

Related Questions