ASP.NET 核心 Web API - 实体类型'IdentityUserRole<long>'需要定义主键

Question

我正在ASP.NET Core Web API中实现IdentityDbContext。

身份模型：

public class ApplicationUser : IdentityUser<long>
{
public DateTime? LastLogin { get; set; }
public ICollection<ApplicationUserRole> UserRoles { get; set; }
}
public class ApplicationRole : IdentityRole<long>
{
public ICollection<ApplicationUserRole> UserRoles { get; set; }
}
public class ApplicationUserRole : IdentityUserRole<long>
{
public virtual ApplicationUser User { get; set; }
public virtual ApplicationRole Role { get; set; }
}

AppDbContext:

public class AppDbContext : IdentityDbContext<ApplicationUser, ApplicationRole, long, IdentityUserClaim<long>, ApplicationUserRole, IdentityUserLogin<long>, IdentityRoleClaim<long>, IdentityUserToken<long>>
{
public AppDbContext(DbContextOptions<AppDbContext> options)
: base(options)
{
}
public DbSet<ApplicationRole> ApplicationRole { get; set; }
public DbSet<ApplicationUserRole> ApplicationUserRole { get; set; }
protected override void OnModelCreating(ModelBuilder builder)
{
base.OnModelCreating(builder);
this.SeedUsers(builder);
this.SeedRoles(builder);
this.SeedUserRoles(builder);
builder.Entity<ApplicationUser>(entity =>
{
entity.Property(u => u.Id).ValueGeneratedOnAdd();
entity.HasIndex(u => u.Email).IsUnique();
});
builder.Entity<ApplicationRole>(entity =>
{
entity.Property(r => r.Id).ValueGeneratedOnAdd();
entity.HasIndex(r => r.Name).IsUnique();
});
builder.Entity<ApplicationUserRole>(userRole =>
{
userRole.HasKey(ur => new { ur.UserId, ur.RoleId });
userRole.HasOne(ur => ur.Role)
.WithMany(r => r.UserRoles)
.HasForeignKey(ur => ur.RoleId)
.IsRequired();
userRole.HasOne(ur => ur.User)
.WithMany(r => r.UserRoles)
.HasForeignKey(ur => ur.UserId)
.IsRequired();
});
}
private void SeedUsers(ModelBuilder builder)
{
ApplicationUser user = new ApplicationUser()
{
UserName = "Admin",
NormalizedUserName = "ADMIN",
Email = "[e-mail]",
SecurityStamp = Guid.NewGuid().ToString("D"),
PhoneNumber = "[phone]"
};
PasswordHasher<ApplicationUser> passwordHasher = new PasswordHasher<ApplicationUser>();
passwordHasher.HashPassword(user, "Admin*123");
builder.Entity<ApplicationUser>().HasData(user);
}
private void SeedRoles(ModelBuilder builder)
{
builder.Entity<ApplicationRole>().HasData(
new ApplicationRole() { Name = "Admin", ConcurrencyStamp = "1", NormalizedName = "ADMIN" },
new ApplicationRole() { Name = "User", ConcurrencyStamp = "2", NormalizedName = "USER" }
);
}
private void SeedUserRoles(ModelBuilder builder)
{
builder.Entity<IdentityUserRole<long>>().HasData(
new IdentityUserRole<long>() { RoleId = 1, UserId = 1 }
);
}
}

Id是自动生成的。

当我执行添加迁移时，我得到了以下错误：

实体类型"IdentityUserRole"需要定义主键。如果您打算使用无钥匙实体类型，请在"OnModelCreating"中调用"HasNoKey"。有关无钥匙实体类型的更多信息，请参见https://go.microsoft.com/fwlink/?linkid=2141943.

如何解决此问题？

感谢

Answer 1

您需要删除AppDbContext:中的一些代码

AppDbContext

public class AppDbContext : IdentityDbContext<ApplicationUser, ApplicationRole, long, IdentityUserClaim<long>, ApplicationUserRole, IdentityUserLogin<long>, IdentityRoleClaim<long>, IdentityUserToken<long>>
{
public AppDbContext(DbContextOptions<AppDbContext> options)
: base(options)
{
}
public DbSet<ApplicationRole> ApplicationRole { get; set; }
public DbSet<ApplicationUserRole> ApplicationUserRole { get; set; }
protected override void OnModelCreating(ModelBuilder builder)
{
base.OnModelCreating(builder);

builder.Entity<ApplicationUser>(entity =>
{
entity.Property(u => u.Id).ValueGeneratedOnAdd();
entity.HasIndex(u => u.Email).IsUnique();
});
builder.Entity<ApplicationRole>(entity =>
{
entity.Property(r => r.Id).ValueGeneratedOnAdd();
entity.HasIndex(r => r.Name).IsUnique();
});

}
private void SeedUsers(ModelBuilder builder)
{
ApplicationUser user = new ApplicationUser()
{
UserName = "Admin",
NormalizedUserName = "ADMIN",
Email = "[e-mail]",
SecurityStamp = Guid.NewGuid().ToString("D"),
PhoneNumber = "[phone]"
};
PasswordHasher<ApplicationUser> passwordHasher = new PasswordHasher<ApplicationUser>();
passwordHasher.HashPassword(user, "Admin*123");
builder.Entity<ApplicationUser>().HasData(user);
}
private void SeedRoles(ModelBuilder builder)
{
builder.Entity<ApplicationRole>().HasData(
new ApplicationRole() { Name = "Admin", ConcurrencyStamp = "1", NormalizedName = "ADMIN" },
new ApplicationRole() { Name = "User", ConcurrencyStamp = "2", NormalizedName = "USER" }
);
}
private void SeedUserRoles(ModelBuilder builder)
{
builder.Entity<IdentityUserRole<long>>().HasData(
new IdentityUserRole<long>() { RoleId = 1, UserId = 1 }
);
}
}

您可以阅读此文档以了解有关"自定义标识"的详细信息：https://learn.microsoft.com/en-us/aspnet/core/security/authentication/customize-identity-model?view=aspnetcore-3.1