EntityFramework not updating column with default value

I am inserting an object into a SQL Server db via the EntityFramework 4 (EF). On the receiving table there is a column of (CreatedDate), which has its default value set to getdate(). So I do not provide it to the EF assuming its value will be defaulted by SQL Server to getdate().

However this doesn’t happen; instead EF return a validation error n SaveChanges().

  • How do you escape double quotes inside a SQL fulltext 'contains' function?
  • Inserting data into SQL Server database using VB.Net
  • SQL Server - how to ensure identity fields increment correctly even in case of rollback
  • Obtain column names from query using wildcard
  • sql server: generate primary key based on counter and another column value
  • Replacing Node name in an XML thats stored in a SQL Server database column
  • Is there any reason that you know for this happening? Please let me know.

    Many thanks.

  • Rollback for bulk copy
  • Add multiple SQL values with same parameterized query?
  • SQL Server gives “duplicate key” error for a non-key property?
  • Code for inserting data into SQL Server database using Enterprise library
  • Sql bulk copy memory issue
  • All records updated with same value when updating database Record
  • 4 Solutions collect form web for “EntityFramework not updating column with default value”

    If you never want to edit that value (like with a created date), you can use:

    [DatabaseGenerated(DatabaseGeneratedOption.Computed)]
    public virtual DateTime CreatedDate { get; set; }
    

    This will tell the Entity Framework that the value is controlled by the database, but will still fetch the value.

    Note that you then cannot change that value, so it’s not a solution if you simply want an initial value.

    If you just want a default value but are still allowed to edit it, or you are using the Entity Framework 5 and below, you have to set the default in code.

    More discussion about this here:

    How to use Default column value from DataBase in Entity Framework?

    Just apply the [DatabaseGenerated(DatabaseGeneratedOption.Identity)] attribute to on the column field in your entity object definition.

    For example:

    public class SomeTable
    {
        ...
    
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public DateTime CreatedDate { get; set; }
    
        ...
    }
    

    This tells the Entity Framework that your column’s initial value is supplied by the database. The value will update automatically from the database after row insertion.

    The correct answer to this issue is to tell Entity Framework that the column is Computed.

    [DatabaseGenerated(DatabaseGeneratedOption.Computed)]
    public virtual DateTime CreatedDate { get; set; }
    

    DatabaseGeneratedOption.Computed means that it is set by the database and can not be changed by Entity Framework. DatabaseGeneratedOption.Identity means that the column is an IDENTITY column, which should only used for autoincrementing numeric primary keys.

    **Note that the documentation for the DatabaseGeneratedOption enumeration doesn’t mention anything about IDENTITY columns (partly because that is a SqlServer specific implimentation detail). Instead it defines the Identity option as “The database generates a value when a row is inserted.” I was actually looking for a way to allow a ModDate to be set using a DEFAULT constraint when the record is created, but to allow it to be modified from Entity Framework when updating the record. So because of the description, I thought I might have found a solution, but trying to modify the ModDate of a record when it was flagged with DatabaseGeneratedOption.Identity threw an exception. So no luck there.

    To get to work i declared a new variable and set that variable to the current time. Then when inserting the data i referenced the variable to the column:

    var db = new YourTableEntities();
    var dateNow = DateTime.Now; 
    
    db.YourTableEntities.Add(new YourTableEntities()
    {
        ColumnAInTable = someAVariable,
        ColumnBInTable = someBVariable,
        ColumnThatShouldDefaultToGetDate = dateNow
    });
    

    Hope this helps!

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.