如何通过扩展IdentityUserRoles类读写AspNetUserRoles表数据

1. 清理重复的DbContext配置 #

你当前的DbContext配置中，UsingEntity已经完整定义了多对多关系和中间表的导航关联，后面重复的modelBuilder.Entity<ApplicationUserRole>()配置会导致冲突，需删除这两段重复代码，保留如下配置即可：

modelBuilder.Entity<ApplicationUser>()
   .HasMany(u => u.Roles)
   .WithMany(r => r.Users)
   .UsingEntity<ApplicationUserRole>(
       au => au.HasOne<ApplicationRole>().WithMany(role => role.UserRoles).HasForeignKey(u => u.RoleId),
       au => au.HasOne<ApplicationUser>().WithMany(user => user.UserRoles).HasForeignKey(r => r.UserId)
   )
   .ToTable("AspNetUserRoles");

2. 修正ApplicationUser的导航属性类型 #

将ApplicationUser中的Roles属性从IEnumerable<ApplicationRole>改为ICollection<ApplicationRole>，EF Core需要可实例化的集合类型来正确加载关联数据：

public class ApplicationUser : IdentityUser
{
    public ICollection<ApplicationRole> Roles { get; set; } = new List<ApplicationRole>();
    public ICollection<ApplicationUserRole> UserRoles { get; set; } = new List<ApplicationUserRole>();
}

同时确保ApplicationRole也定义对应的导航属性：

public class ApplicationRole : IdentityRole
{
    public ICollection<ApplicationUser> Users { get; set; } = new List<ApplicationUser>();
    public ICollection<ApplicationUserRole> UserRoles { get; set; } = new List<ApplicationUserRole>();
}

3. 正确加载UserRoles关联数据 #

使用UserManager查询用户时，直接通过Include方法包含UserRoles，比后续手动LoadAsync更可靠（避免上下文生命周期问题）：

var user = await _context.Users
    .Include(u => u.UserRoles)
    .ThenInclude(ur => ur.Role) // 按需加载关联的Role数据
    .FirstOrDefaultAsync(u => u.Email == username);

if (user != null && await userManager.CheckPasswordAsync(user, password))
{
    return user;
}

如果必须使用UserManager.FindByEmailAsync，需确保当前_context和userManager使用同一个上下文实例，再执行加载：

var user = await userManager.FindByEmailAsync(username);
if (user != null && await userManager.CheckPasswordAsync(user, password))
{
    await _context.Entry(user)
        .Collection(u => u.UserRoles)
        .Query() // 可添加过滤条件，比如只加载IsActive=true的记录
        .Include(ur => ur.Role) // 按需加载Role
        .LoadAsync();
    return user;
}

4. 修改AspNetUserRoles表的新增列 #

加载到UserRoles集合后，直接修改对应属性并保存上下文即可：

// 找到用户对应的目标UserRole记录
var targetUserRole = user.UserRoles.FirstOrDefault(ur => ur.RoleId == "目标角色ID");
if (targetUserRole != null)
{
    targetUserRole.IsDefault = true;
    targetUserRole.IsActive = true;
    targetUserRole.IsDeactivated = false;
    await _context.SaveChangesAsync();
}

内容的提问来源于stack exchange，提问作者CodePull