ASP.NET Core中如何从数据库获取Student和Tutor子模型？

要正确从数据库获取Student和Tutor实例，需要从注册逻辑修正、EF Core继承配置、查询方式优化三个方面入手，以下是具体步骤：

1. 修正注册逻辑：创建对应子类实例 #

你当前注册时创建的是基类User对象，导致数据库中没有存储Student/Tutor的专属字段，后续无法正确加载子类数据。需要根据用户角色创建对应的子类实例：

public async Task<IActionResult> RegisterUser(RegisterUser model)
{
    if (ModelState.IsValid)
    {
        IdentityRole role = _context.Roles.FirstOrDefault(r => r.Name == model.Role);
        if (role == null)
        {
            ModelState.AddModelError(string.Empty, "指定角色不存在");
            return View(model);
        }

        User user;
        // 根据角色创建对应子类实例
        if (model.Role == "student")
        {
            user = new Student 
            { 
                Email = model.Email, 
                UserName = model.Email, 
                Name = model.Name, 
                RoleId = role.Id, 
                Role = role 
            };
        }
        else if (model.Role == "teacher")
        {
            user = new Tutor 
            { 
                Email = model.Email, 
                UserName = model.Email, 
                Name = model.Name, 
                RoleId = role.Id, 
                Role = role 
            };
        }
        else
        {
            ModelState.AddModelError(string.Empty, "不支持的角色类型");
            return View(model);
        }

        var result = await _userManager.CreateAsync(user, model.Password);
        if (result.Succeeded)
        {
            await _userManager.AddToRoleAsync(user, model.Role);
            await _signInManager.SignInAsync(user, false);

            var code = await _userManager.GenerateEmailConfirmationTokenAsync(user);
            var callbackUrl = Url.Action(
                "ConfirmEmail",
                "User",
                new { userId = user.Id, code = code },
                protocol: HttpContext.Request.Scheme);

            Emailer.SendEmailAsync(model.Email, "确认你的账户",
                $"请点击<a href='{callbackUrl}'>链接</a>完成邮箱验证");

            return Content("请检查邮箱完成验证");
        }
        else
        {
            foreach (var error in result.Errors)
            {
                ModelState.AddModelError(string.Empty, error.Description);
            }
        }
    }
    return View(model);
}

2. 配置EF Core继承映射 #

EF Core默认使用**TPH（每个层次结构一张表）**策略处理继承，需要在DbContext中声明子类的DbSet，确保EF能识别并正确映射数据：

public class YourDbContext : IdentityDbContext<User>
{
    // 添加子类的DbSet
    public DbSet<Student> Students { get; set; }
    public DbSet<Tutor> Tutors { get; set; }

    public YourDbContext(DbContextOptions<YourDbContext> options) : base(options) { }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);
        
        // 可选：自定义鉴别器字段（默认是Discriminator）
        modelBuilder.Entity<User>()
            .HasDiscriminator<string>("UserType")
            .HasValue<Student>("student")
            .HasValue<Tutor>("teacher");
    }
}

3. 优化查询方式：直接查询子类DbSet #

避免从_context.Users查询后强转（EF不会自动将基类实例转为子类），直接通过子类的DbSet查询，EF会自动筛选对应类型的数据并返回子类实例：

教师主页查询示例 #

[HttpGet]
[Authorize(Roles = "teacher")]
public async Task<IActionResult> AccountHomePageTutor()
{
    var userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
    // 直接从Tutors DbSet查询，自动返回Tutor实例
    Tutor tutor = await _context.Tutors
        .Include(t => t.Role) // 按需关联查询Role
        .FirstOrDefaultAsync(t => t.Id == userId);

    if (tutor != null)
    {
        return View(tutor);
    }
    return NotFound();
}

学生主页查询示例 #

[HttpGet]
[Authorize(Roles = "student")]
public async Task<IActionResult> AccountHomePageStudent()
{
    var userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
    // 直接从Students DbSet查询，自动返回Student实例
    Student student = await _context.Students
        .Include(s => s.Tutors) // 按需关联查询Tutors
        .Include(s => s.Role)
        .FirstOrDefaultAsync(s => s.Id == userId);

    if (student != null)
    {
        return View(student);
    }
    return NotFound();
}

4. 修正主页跳转逻辑 #

你之前的AccountHomePage中，学生角色错误跳转到了教师主页，修正如下：

public async Task<IActionResult> AccountHomePage()
{
    User user = await _userManager.FindByNameAsync(User.Identity.Name);
    user.Role = _context.Roles.FirstOrDefault(r => r.Id == user.RoleId);
    if (user.Role.Name == "teacher")
    {
        return RedirectToAction("AccountHomePageTutor", "Account");
    }
    else if(user.Role.Name == "student")
    {
        return RedirectToAction("AccountHomePageStudent", "Account");
    }
    return NotFound();
}

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