Auto increment PK starting from zero - EF Core code-first

Question

I'm using ASP.NET Core and EF Core with code-first approach. Database is SQL Server. Is it possible to increment Id primary key starting at 0?

Answer 1

With EF Core 3.x you can use UseIdentityColumn:

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    // ...

    modelBuilder.Entity<Blog>()
        .Property(x => x.Id)
        .UseIdentityColumn(seed: 0, increment: 1);
}

Answer 2

Is it posible to increment Id primary key starting at 0?

Yes. EF Core supports Sequences, which you can start wherever you want.

EG:

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

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.HasSequence<int>("Order_seq", schema: "dbo")
            .StartsAt(0)
            .IncrementsBy(1);

        modelBuilder.Entity<Order>()
            .Property(o => o.OrderNo)
            .HasDefaultValueSql("NEXT VALUE FOR dbo.Order_seq");
    }
}

public class Order
{
    public int OrderId { get; set; }
    public int OrderNo { get; set; }
    public string Url { get; set; }
}

https://docs.microsoft.com/en-us/ef/core/modeling/relational/sequences