CODEWITHSUNDEEP
entity-framework
TheWebGuy
TheWebGuy

Reputation: 12545

Entity Framework and Default Date

I have a table in SQL, within that table I have DateTime column with a default value of GetDate()

In entity framework I would like it to use the SQL date time instead of using the local date time of the computer the console app is running on (the SQL server is 1 hour behind).

The column does not allow nulls either, currently it passes in a date value of 1/1/0001 and I get an error:

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

Thank you!

Upvotes: 7

Views: 9428

Answers (3)

John M
John M

Reputation: 2600

If you're using Fluent API, just add this to your DbContext class:

        modelBuilder.Entity<EntityName>()
            .Property(p => p.PropertyName)
            .HasDatabaseGeneratedOption(DatabaseGeneratedOption.Computed);

Upvotes: 3

Sergey Berezovskiy
Sergey Berezovskiy

Reputation: 236208

  1. Open edmx designer
  2. Select your DateTime column
  3. Go to properties and change StoreGeneratedPattern from None to Computed

That will tell EF not to insert value for that column, thus column will get default value generated by database. Keep in mind that you will not be able to pass some value.

Upvotes: 21

user2065203
user2065203

Reputation: 11

Set columnType for that entity in OnModelCreating Method: modelBuilder.Entity().Property(s => s.ColumnName).HasColumnType("datetime2");

Upvotes: 1

Related Questions