How to insert a default value in sql table column in code

Question

I want to insert in a column a value like Eastern Time Zone but I didn't get any value in the column. In the code below I try, unsuccessfully, to insert a default value:

 [MaxLength(150), DefaultValue("Eastern Time Zone")]
 public string Timezone { get; set; }

Could you please help me to insert a default value?

Can you please check this link stackoverflow.com/questions/19554050/… — jishan siddique
– jishan siddique, Commented Feb 6, 2020 at 6:25

Athanasios Kataras · Accepted Answer · 2020-02-06 06:45:21Z

1

You can use the following from the fluent API: https://www.learnentityframeworkcore.com/configuration/fluent-api/hasdefaultvaluesql-method

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<YourEntity>()
        .Property(b => b.Timezone)
        .HasDefaultValueSql("Eastern Time Zone");
}

answered Feb 6, 2020 at 6:45

Athanasios Kataras

26.7k6 gold badges40 silver badges67 bronze badges

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

Collectives™ on Stack Overflow

How to insert a default value in sql table column in code

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related