Details
MS SQL Server Generate Sequential IDs
Override the OnModelCreating()
method of your ApplicationDbContext
and add this:
builder.Entity<ApplicationUser>()
.Property(a => a.Id)
.ValueGeneratedOnAdd()
.HasDefaultValueSql("NEWSEQUENTIALID()");
Do the same for all entities that have Guid IDs.