Entity Framework Core 2.0 default value for common property in many tables

Question

I am doing code first EF Core 2.0 migrations. I have few columns which are common across all entities. All entities inherit this class as shown below.

How do I set the default value for CreateDate as current date, CreateBy as 'System' and IsDeleted as 0?

public class BaseEntity
{
    public DateTime CreateDate { get; set; }

    public string CreateBy { get; set; }

    public bool IsDeleted { get; set; }
}

I know how to do this for a single property. ie.

class MyContext : DbContext
{
    public DbSet<CaseDetails> CaseDetails{ get; set; }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<CaseDetail>()
            .Property(b => b.CreateDate)
            .HasDefaultValueSql("getutcdate()");

        modelBuilder.Entity<CaseDetail>()
            .Property(b => b.CreateBy)
            .HasDefaultValue("System");

        modelBuilder.Entity<CaseDetail>()
            .Property(b => b.IsDeleted)
            .HasDefaultValue("0()");
    }
}

Can anyone help me how to do this in an efficient way so it will be available for all entities?

Thanks

Similar to [Filter all queries (trying to achieve soft delete)](https://stackoverflow.com/questions/45096799/filter-all-queries-trying-to-achieve-soft-delete/45097532#45097532), but configuring properties instead of setting filter. — Ivan Stoev, Jan 10 '18 at 12:03

score 14 · Answer 1 · answered Jan 10 '18 at 16:40

Here is one way to do it.

foreach (var entityType in modelBuilder.Model.GetEntityTypes()
    .Where(t => t.ClrType.IsSubclassOf(typeof(BaseEntity))))
{
    modelBuilder.Entity(
        entityType.Name,
        x =>
        {
            x.Property("CreateDate")
                .HasDefaultValueSql("getutcdate()");

            x.Property("CreateBy")
                .HasDefaultValue("System");

            x.Property("IsDeleted")
                .HasDefaultValue(false);
        });
}

You are my hero. You saved my hours. – Adil Ansari Sep 11 '20 at 15:20 — Adil Ansari, Sep 11 '20 at 15:20

score 7 · Accepted Answer · answered Feb 08 '18 at 11:54

7

Correct way with latest version of net.core 2.0:

    foreach (var entityType in builder.Model.GetEntityTypes()
        .Where(e => typeof(Entity<int>).IsAssignableFrom(e.ClrType)))
    {
        builder
            .Entity(entityType.ClrType)
            .Property("CreatedDate")
            .HasDefaultValueSql("getutcdate()");
    }

answered Feb 08 '18 at 11:54

sensei

7,044
10
57
125

Thank you. may i know how to do this in EF6 as well. – Mukil Deepthi Feb 14 '18 at 16:25

Entity Framework Core 2.0 default value for common property in many tables

2 Answers2