Entity Framework and Default Date

entity-framework

Question

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!

1
5
2/6/2013 12:17:19 PM

Accepted Answer

  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.

21
2/12/2013 4:06:25 PM

Popular Answer

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

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


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow