EntityFramework TPH继承下，ASP.NET Identity用户子类数据检索问题

方案1：类型转换过滤 #

GetUsersInRoleAsync返回的ApplicationUser集合中，属于Teacher角色的用户实际是Teacher类型的实例，直接用OfType<T>过滤并转换类型即可访问专属属性：

var roleUsers = await _userManager.GetUsersInRoleAsync("Teacher");
var teachers = roleUsers.OfType<Teacher>();

foreach (var teacher in teachers)
{
    string courseName = teacher.Course; // 正常访问Course属性
}

如果需要单独处理非Teacher类型的用户，也可以用is关键字做安全转换：

foreach (var user in roleUsers)
{
    if (user is Teacher teacher)
    {
        string courseName = teacher.Course;
    }
}

方案2：直接查询数据库 #

通过注入的ApplicationDbContext直接查询Teacher实体集，关联角色表过滤数据，跳过UserManager的类型限制：

首先确保ApplicationDbContext中包含Teacher的DbSet：

public class ApplicationDbContext : IdentityDbContext<ApplicationUser>
{
    public DbSet<Teacher> Teachers { get; set; }

    // 其他构造函数及配置
}

然后执行查询：

var teachers = await _context.Teachers
    .Join(_context.UserRoles, 
          teacher => teacher.Id, 
          userRole => userRole.UserId, 
          (teacher, userRole) => new { Teacher = teacher, UserRole = userRole })
    .Join(_context.Roles, 
          tu => tu.UserRole.RoleId, 
          role => role.Id, 
          (tu, role) => new { tu.Teacher, Role = role })
    .Where(x => x.Role.Name == "Teacher")
    .Select(x => x.Teacher)
    .ToListAsync();

方案3：封装UserManager扩展方法 #

把类型转换逻辑封装成扩展方法，方便在项目中复用：

public static class UserManagerExtensions
{
    public static async Task<IList<Teacher>> GetTeachersInRoleAsync(this UserManager<ApplicationUser> userManager, string roleName)
    {
        var users = await userManager.GetUsersInRoleAsync(roleName);
        return users.OfType<Teacher>().ToList();
    }
}

调用时直接使用扩展方法：

var teachers = await _userManager.GetTeachersInRoleAsync("Teacher");
foreach(var teacher in teachers)
{
    Console.WriteLine(teacher.Course);
}

方案4：注册专属Teacher的UserManager（适合多用户类型场景） #

如果项目需要独立管理Teacher用户，可以单独注册UserManager<Teacher>的依赖注入服务，修改Program.cs/Startup.cs：

// 保留原ApplicationUser的Identity配置
builder.Services.AddDefaultIdentity<ApplicationUser>(options => options.SignIn.RequireConfirmedAccount = true)
    .AddEntityFrameworkStores<ApplicationDbContext>();

// 额外注册Teacher的UserManager
builder.Services.AddIdentityCore<Teacher>()
    .AddRoles<IdentityRole>()
    .AddEntityFrameworkStores<ApplicationDbContext>()
    .AddUserManager<UserManager<Teacher>>();

之后在需要的地方注入UserManager<Teacher>：

private readonly UserManager<Teacher> _teacherUserManager;

public YourController(UserManager<Teacher> teacherUserManager)
{
    _teacherUserManager = teacherUserManager;
}

注意：此方案会增加系统复杂度，适合确实需要区分不同用户类型管理的场景，初期项目或简单场景优先考虑前三种方案。

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