Seed admin user to database OnModelCreating-CodePudding

The

ApplicationRole.cs:

public class ApplicationRole : IdentityRole<Guid> { public virtual ICollection<ApplicationUserRole> UserRoles { get; set; } }

ApplicationDbContext:

public class ApplicationDbContext : IdentityDbContext<ApplicationUser, ApplicationRole, Guid, IdentityUserClaim<Guid>, ApplicationUserRole, IdentityUserLogin<Guid>, IdentityRoleClaim<Guid>, IdentityUserToken<Guid>> { public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options) { } ... }

CodePudding user response：

I can't really say where the issue is without running some code but I can show you my implementation and maybe it will ring a bell. This is my version:

public class SessionDbContext : IdentityDbContext<MachineUserIdentity, IdentityRole<Guid>, Guid> { ... protected override void OnModelCreating(ModelBuilder modelBuilder) { base.OnModelCreating(modelBuilder); // Default users modelBuilder.ApplyConfiguration(new IdentityUserModelConfig()); // Default roles modelBuilder.ApplyConfiguration(new IdentityRoleModelConfig()); // User claims modelBuilder.ApplyConfiguration(new IdentityUserClaimsModelConfig()); // Role claims modelBuilder.ApplyConfiguration(new IdentityRoleClaimsModelConfig()); // User roles assignment modelBuilder.ApplyConfiguration(new IdentityUserRoleModelConfig()); } }

Foreach data table I've created a separate IEntityTypeConfiguration but it shouldn't change anything. Here are the implementations for Users, Roles and UserRoles:

IEntityTypeConfiguration<MachineUserIdentity> with MachineUserIdentity inheriting IdentityUser<Guid> :

public void Configure(EntityTypeBuilder<MachineUserIdentity> builder) { // Seed default roles builder.HasData(SeedHelpers.DefaultUsers); }

IEntityTypeConfiguration<IdentityRole<Guid>>:

public void Configure(EntityTypeBuilder<IdentityRole<Guid>> builder) { // Seed default roles builder.HasData(SeedHelpers.GenerateDefaultRoles()); }

IEntityTypeConfiguration<IdentityUserRole<Guid>>:

public void Configure(EntityTypeBuilder<IdentityUserRole<Guid>> builder) { // Seed default roles builder.HasData(SeedHelpers.GenerateUserRolesAssignment()); }

Very similar to what you are doing. Finally, I have a seeding helper class where I define data like this:

internal const string GUID_USER_OPERATOR = "491a282c-3af1-4d45-b6a1-6014b8195744"; internal const string GUID_USER_SERVICE = "337acfd6-fde7-4d5c-9c0b-08fed843a3ed"; internal const string GUID_ROLE_OPERATOR = "d80a2a14-78a7-4e9d-b228-1cd259bd8cd3"; internal const string GUID_ROLE_SERVICE = "69605900-4fb1-4558-a9d4-6bdf3f184819"; // Password do not belong here, move them to a key vault // This is just for demo purposes internal const string ID_DEFAULT_ACCOUNT = "ADMIN"; internal const string ID_DEFAULT_PASSWORD = "ADMIN"; internal const string ID_SERVICE_ACCOUNT = "SERVICE"; internal const string ID_SERVICE_PASSWORD = "SERVICE1234"; internal static List<MachineUserIdentity> DefaultUsers = new() { new() { Id = Guid.Parse(GUID_USER_OPERATOR), UserName = ID_DEFAULT_ACCOUNT, NormalizedUserName = ID_DEFAULT_ACCOUNT, Role = MachineRoleId.Operator.ToString(), PasswordHash = hasher.HashPassword(null, ID_DEFAULT_PASSWORD), }, new() { Id = Guid.Parse(GUID_USER_SERVICE), UserName = ID_SERVICE_ACCOUNT, NormalizedUserName = ID_SERVICE_ACCOUNT, Role = MachineRoleId.Service.ToString(), PasswordHash = hasher.HashPassword(null, ID_SERVICE_PASSWORD), } }; internal static IdentityRole<Guid>[] GenerateDefaultRoles() { return new[] { new(MachineRoleId.Operator.ToString()) { Id = Guid.Parse(GUID_ROLE_OPERATOR), Name = MachineRoleId.Operator.ToString(), NormalizedName = MachineRoleId.Operator.ToString().ToUpper(), }, new IdentityRole<Guid> { Id = Guid.Parse(GUID_ROLE_SERVICE), Name = MachineRoleId.Service.ToString(), NormalizedName = MachineRoleId.Service.ToString().ToUpper(), } }; } internal static IdentityUserRole<Guid>[] GenerateUserRolesAssignment() { return new[] { new() { RoleId = Guid.Parse(GUID_ROLE_OPERATOR), UserId = Guid.Parse(GUID_USER_OPERATOR), }, new IdentityUserRole<Guid> { RoleId = Guid.Parse(GUID_ROLE_SERVICE), UserId = Guid.Parse(GUID_USER_SERVICE), } }; }

I guess there isn't much difference except that I'm using hard-coded GUIDs (my own choice to have same identifiers on all target machines) and that I do not explicitly declare the key of the UserRole table like you.

Hope this helps ;)

CodePudding user response：

Not sure if this will solve your issue but I've noticed that you are assigning new GUID value to ADMIN_ID and then basically passing the same value to ROLE_ID. Assign a new unique value to ROLE_ID then retry the seed.