CODEWITHSUNDEEP
asp.netentity-frameworkasp.net-coreentity-framework-6
Jawed Khalil
Jawed Khalil

Reputation: 23

How to auto increment Id with VARCHAR or NVARCHAR in Entity Framework Core?

I used to do that using a compound column in my SQL code before.

[ID] [int] IDENTITY(1,1) NOT NULL,
[PreFix] [varchar](50) NOT NULL,
[EmployeeNo]  AS ([PreFix]+ RIGHT('0000000' + CAST(Id AS VARCHAR(7)), 7)) PERSISTED,

Upvotes: 1

Views: 1326

Answers (1)

Elham Kohestani
Elham Kohestani

Reputation: 3162

There are mainly different workarounds, the simplest would be modifying the OnModelCreating method to use one of the fluent API functions HasComputedColumnSql on the computed column.

Code First Approach

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<Employee>()
    .Property(e => e.EmployeeNo)
    .HasComputedColumnSql("[PreFix]+ RIGHT('0000000' + CAST(Id AS VARCHAR(7)), 7)");
}

Database First Approach

For a database first approach you could still have the computation logic defined while creating the table and use the following modification in the context side of the entity framework core.

protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Contact>()
            .Property(p => p.EmployeeNo)
            .ValueGeneratedOnAdd();
    }

Upvotes: 2

Related Questions