How to configure an Identity column using Entity Framework Core?

c# entity-framework-core

Question

How do I create an Auto increment identity column in Entity Framework Core?

Obviously I can do it using fluent API for EF6 for example.

Accepted Answer

Since there is very little EF7 documentation, much of what we know we have to glean from the source or unit tests. According to the following two unit tests in the EF7 source...

Here and Here

You would configure a property for Identity like this:

b.Property(e => e.Id).ForSqlServer().UseIdentity();

And you would configure a property for Sequences like this:

ForSqlServer().UseSequence();

The urls have changed due to the aspnet-core reorg, and the methods have also changed since this was first asked.

Here and Here

if (_useSequence) 
{
    b.Property(e => e.Identifier).ForSqlServerUseSequenceHiLo();
} 
else 
{
    b.Property(e => e.Identifier).UseSqlServerIdentityColumn();
}

It's possible these urls might change again (which is why I include the relevant code), but it's ridiculously easy to just look at the url and go to the site and figure out what the new url is.

Really, the whole point of my answer is that you can figure this stuff out yourself just by going and looking at the unit tests in the source code on GitHub. You shouldn't need someone to spoon feed it to you.

EDIT: Updated links to version 2.1 (still works for 1.1 and 2.0 as well)


Popular Answer

In latest version of EF7 there is a new extension method to set identity column

protected override void OnModelCreating(ModelBuilder modelBuilder)
{    
  modelBuilder.Entity<MyEntity>(b =>
  {
    b.HasKey(e => e.Identifier);
    b.Property(e => e.Identifier).ValueGeneratedOnAdd();
  });
}


Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why