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.