How to make EF-Core use a Guid instead of String for its ID/Primary key

by

You need custom ApplicationUser inherit from IdentityUser<TKey> and custom Role inherit from IdentityRole<TKey> 

public class ApplicationUser : IdentityUser<Guid> { }    
public class Role : IdentityRole<Guid> { }

Custom context class inherit from IdentityDbContext<ApplicationUser, Role, TKey> and use fluent api for auto generate guid keys.

public class ApplicationDbContext : IdentityDbContext<ApplicationUser, Role, Guid>
{
    protected override void OnModelCreating(ModelBuilder builder)
    {
        base.OnModelCreating(builder);

        builder.Entity<ApplicationUser>(b =>
        {
            b.Property(u => u.Id).HasDefaultValueSql("newsequentialid()");
        });

        builder.Entity<Role>(b =>
        {
            b.Property(u => u.Id).HasDefaultValueSql("newsequentialid()");
        });
    }
}

then in Startup add Identity service to container like this

services.AddIdentity<ApplicationUser, Role>()
        .AddEntityFrameworkStores<ApplicationDbContext, Guid>()
        .AddDefaultTokenProviders()
        .AddUserStore<UserStore<ApplicationUser, Role, ApplicationDbContext, Guid>> ()
        .AddRoleStore<RoleStore<Role, ApplicationDbContext, Guid>>();

If you have not created the database, clear the migrations folder and run ef commands

More Related Contents:

  1. Unable to edit db entries using EFCore, EntityState.Modified: “Database operation expected to affect 1 row(s) but actually affected 0 row(s).”
  2. How to get current user in asp.net core
  3. Dynamically change connection string in Asp.Net Core
  4. Configure the authorization server endpoint
  5. .Net Core 3.0 possible object cycle was detected which is not supported
  6. .NET Core 2.1 Identity get all users with their associated roles
  7. IdentityServer4 Role Based Authorization for Web API with ASP.NET Core Identity
  8. The entity type ‘Microsoft.AspNet.Identity.EntityFramework.IdentityUserLogin’ requires a key to be defined
  9. Command dotnet ef not found
  10. How to create roles in ASP.NET Core and assign them to users?
  11. Unable to create migrations after upgrading to ASP.NET Core 2.0
  12. Dynamically changing schema in Entity Framework Core
  13. ‘No database provider has been configured for this DbContext’ on SignInManager.PasswordSignInAsync
  14. How to unapply a migration in ASP.NET Core with EF Core
  15. EF CORE 2.1 HasConversion on all properties of type datetime
  16. Is there an Entity Framework 7 Database-First POCO Generator?
  17. ASP.NET Core Identity – get current user
  18. loading a full hierarchy from a self referencing table with EntityFramework.Core
  19. Avoid or control circular references in Entity Framework Core
  20. Configuring Dbcontext as Transient
  21. Add migration with different assembly
  22. Register AspNetCore 2.1 Identity system with DbContext interface
  23. Entity Framework Core: `SqlNullValueException: Data is Null.` How to troubleshoot?
  24. The entity type ‘IdentityUserLogin’ requires a primary key to be defined [duplicate]
  25. How to load navigation properties on an IdentityUser with UserManager
  26. How to get user information in DbContext using Net Core
  27. How should I manage DbContext Lifetime in MVC Core?
  28. Implementing recursive property loading in EF Core
  29. How to resolve .net core build error NETDSDK1061 and warning MSB3277
  30. Update-Database command is not working in ASP.Net Core / Entity Framework Core because object in database already exists

Leave a Comment