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

asp.net-core-2.0 entity-framework-core

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

1
3
1/10/2018 12:03:32 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

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()");
    }
2
2/8/2018 11:54:37 AM

Popular Answer

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);
        });
}
bricelam

Related Questions

Entity Framework default value for null properties on select

I am possibly looking at moving from nHibernate for my ORM to entity framework and I am running into a small issue if the database is has a null value, but the entity property is not nullable. nHibernate will just set the default value and move on and will not cause any exceptions. Meaning if I have a boolean property it will be false if the data...
asp.net-web-api2 c# entity-framework entity-framework-6
asked by Rodney Pannell

Override sql default value on insert using Entity Framework Core (7)

I have a table with a column [CreatedAtIsoUtc] that sets a Sql Server default value...migrationBuilder.CreateTable( name: "CurrentAccountLedger", columns: table => new { Id = table.Column<Guid>(nullable: false, defaultValueSql: "newsequentialid()"), CreatedAtIsoUtc = table.Column<D...
entity-framework entity-framework-core
asked by sf.

Same property name in several child entities with Entity Framework Core 2.0

I'm currently using the simple model below. It's pretty straightforward: we have resources and they can be ...Room..., ...EmptyOffice... (...) or ...Service.... ...Room... and ...EmptyOffice... can have a capacity, but NOT ...Service.......public abstract class Resource : Entity { public string Name { get; set; } } public class Room : Resource...
.net-core-2.0 c# entity-framework entity-framework-core
asked by Seb

How to specify default property values for owned entity types in Entity Framework Core 2.0?

I have a simple POCO type, say something like...public class OwnedEntity { public string stringProperty { get; set; } public decimal decimalProperty { get; set; } public bool boolProperty { get; set; } public int intProperty { get; set; } } ...and an actual entity with an ...OwnedEntity... reference...public class SomeEntity { ...
asp.net entity-framework-core
asked by qCring

Entity Framework Core Default Value Not Loading After Add Range

Net Core 2.0 Entity Framework. When I try to insert data using ..._context.UserTask.AddRange(userTasks)..., the ...TaskID... is not being updated after invoking ...SaveChanges().... Below is the code I'm using....public partial class UserTask { public Guid TaskID { get; set; } public string Text{get;set;} } var tasks = taskTexts.Select(s =...
.net-core entity-framework-core
asked by Joe Samraj

Entity Framework Core - Generically assign dynamic values to common columns in code first

I am trying to assign values to columns common in all tables using code at one place. My scenario is as below....I have common columns in all tables like "CreatedBy", "CompanyId" which are derived from BaseEntity....public abstract class BaseEntity { public DateTime? CreatedDateTime { get; set; } public DateTime? ModifiedDateTi...
c# ef-code-first entity-framework-core sql-server
asked by tech-y

Entity Framework Core, setting common property for all Entites in one go

How can someone set a value for a prop on all entities without having to do so explicit ...I have this base ... public abstract class Base<TKey> { public TKey Id { get; private set; } public DateTime CreatedOn { get; private set; } } ...from which all other entities derive from. As you can see it has 2 fields, I would like t...
ef-fluent-api entity-framework entity-framework-core
asked by boris

Entity Framework Core code first default values for PostgreSQL

So far I read the docs, tutorials google brought up and other SO questions but it seems I miss something and I don't get it (to work)....I try to implement a really tiny PostgreSQL database for a .NET Core 2.1 web api (microservice). I am used to the database first approach but for this service I decided to give the code first approach a try....I a...
.net-core .net-core-2.1 entity-framework-core npgsql postgresql
asked by monty

Newly inserted row value to be returned using entity framework core 2.0

I am using ExcecuteSqlCommand for update and insert, which will return an integer but i want the entire inserted or updated row. Using FromSql the updation and insertion are not happening, i am able to fetch only the items. How can i achieve this?
asp.net-core entity-framework-core
asked by Aditya dalai

Default value not respected with Entity Framework Core Insert

My SQL Server 2017 table is created in Transact-SQL as follows:...SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[JobTag] ( [JobId] [int] NOT NULL, [Name] [nvarchar](64) NOT NULL, [Created] [datetime] NOT NULL, [Value] [nvarchar](max) NULL, [Comment] [nvarchar](2048) NULL, CONSTRAINT [PK_JobTag_1] ...
entity-framework-core
asked by Kirsten Greed

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow