How to force default values in an insert with EntityFramework core?

Question

When adding a record with EntityFramework Core, if I want to force a column which has a default value to another value, the default value is taken.

SQL

CREATE TABLE MyEntity(
    Id INT IDENTITY(1,1) NOT NULL, 
    MyProperty1 VARCHAR(50),
    MyBool BIT NOT NULL DEFAULT 1
);

.NET

public void insertNewMyEntity()
{
    MyEntity me = New MyEntity();
    me.MyProperty1 = "Testing insert and default values with EF Core";
    me.MyBool = 0;
    dbContext.MyEntity.Add(me);
    dbContext.SaveChanges();
}

In the Database, there's MyBool = 1 because EntityFramework send the following command:

INSERT INTO MyEntity(MyProperty1) VALUES ("Testing insert and default values with EF Core");

Instead of:

INSERT INTO MyEntity(MyProperty1, MyBool) VALUES ("Testing insert and default values with EF Core", 0);

I could add data annotation [DataGenerated(DataGeneratedOption.None)] on MyBool but I don't want to redo all the data annotations in all entities after each classes generation with EF.

Korgoth · Accepted Answer · 2016-12-22 08:28:14Z

2

I add data annotation [DataGenerated(DataGeneratedOption.None)] on the properties with the configBuilder object :

modelBuilder.Entity<MyEntity>().Property(a => a.MyBool).ValueGeneratedNever();

answered Dec 22, 2016 at 8:28

Korgoth

1191 gold badge2 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

How to force default values in an insert with EntityFramework core?

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