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?

Answer 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");
}