.NET 7 Web API一对一关系导航属性为空问题求助

问题描述 #

在.NET 7 Web API的AuthService中同时创建User（父实体）与Researcher（依赖实体）时，Researcher的UserId属性值正确，但User.Researcher和Researcher.User两个导航属性均为空，需解决此问题以确保User包含Researcher的引用。

补充验证：多次测试确认，仅Researcher.UserId值正确，双向导航属性均为null。

API响应示例 #

[
  {
    "userId": "d8725e37-b3b2-4851-8ae7-07afadb92adc",
    "email": "a@email.com",
    "passwordHash": "$2a$11$hfvUxb44m.b0/RYWBwyQvuaxF0mcRhmiGmqjldvOlDiAmnOiHF92i",
    "researcher": null
  },
  {
    "userId": "3eb55b33-8c41-405e-a19c-5390c472302e",
    "email": "b@email.com",
    "passwordHash": "$2a$11$uwvZErMttnzYRpwUO2LfOOvvjURZrSs5V68lp2L8.MtC6gubs7bkO",
    "researcher": null
  },
  {
    "userId": "b2fc3e76-02c5-48a4-b865-b686870e429a",
    "email": "c@email.com",
    "passwordHash": "$2a$11$hKDeNsfK5qnPf5uFujKgu.LB5d/FSDVFnj.vN49vAmd.zZn/ogaLW",
    "researcher": null
  }
]

实体定义 #

User.cs（父实体）

public class User
{
    public Guid UserId { get; set; } = Guid.NewGuid();
    public string Email { get; set; } = string.Empty;
    public string PasswordHash { get; set; } = string.Empty;
    public Researcher? Researcher { get; set; }
}

Researcher.cs（依赖实体）

public class Researcher
{
    [Key]
    public int ResearcherId { get; set; }
    public string FirstName { get; set; } = string.Empty;
    public string LastName { get; set; } = string.Empty;
    public string Field { get; set; } = string.Empty;
    public string AreaOfFocus { get; set; } = string.Empty;
    public string Biography { get; set; } = string.Empty;
    [ForeignKey("UserId")]
    public User? User { get; set; }
    public List<ResearcherArticle>? JoinEntities { get; set; }
}

创建实体的服务方法 #

public async Task<ServiceResponse<UserRegisterResponseDto>> RegisterUser(UserRegisterRequestDto request)
{
    List<string> userValidationMessages = ValidateUser(request);

    var serviceResponse = new ServiceResponse<UserRegisterResponseDto>();

    if (userValidationMessages.Count > 0)
    {
        serviceResponse.Success = false;
        serviceResponse.Messages = userValidationMessages;
        return serviceResponse;
    }

    string passwordHash = BCrypt.Net.BCrypt.HashPassword(request.Password);
    User userToReturn = new()
    {
        Email = request.Email,
        PasswordHash = passwordHash
    };

    Researcher reasercherToAdd = new()
    {
        User = userToReturn,
    };

    _db.Researchers.Add(reasercherToAdd);

    userToReturn.Researcher = reasercherToAdd;
    _db.Users.Add(userToReturn);
    bool userAdded = await _db.SaveChangesAsync() > 0;

    if (!userAdded)
    {
        serviceResponse.Success = false;
        serviceResponse.Messages = new List<string>() { userAdded.ToString() };
        return serviceResponse;
    }

    serviceResponse.Success = true;
    serviceResponse.Messages = new List<string>() { "Registration successful" };
   
    return serviceResponse;
}

解决方案 #

1. 补全实体外键字段并明确关系配置 #

当前Researcher实体缺少显式的UserId外键字段，EF Core无法正确绑定双向导航关系。修改Researcher类：

public class Researcher
{
    [Key]
    public int ResearcherId { get; set; }
    public string FirstName { get; set; } = string.Empty;
    public string LastName { get; set; } = string.Empty;
    public string Field { get; set; } = string.Empty;
    public string AreaOfFocus { get; set; } = string.Empty;
    public string Biography { get; set; } = string.Empty;
    
    // 添加显式外键字段
    public Guid UserId { get; set; }
    
    [ForeignKey("UserId")]
    public User? User { get; set; }
    public List<ResearcherArticle>? JoinEntities { get; set; }
}

同时在DbContext的OnModelCreating方法中用Fluent API明确一对一双向关系：

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<User>()
        .HasOne(u => u.Researcher)
        .WithOne(r => r.User)
        .HasForeignKey<Researcher>(r => r.UserId)
        .OnDelete(DeleteBehavior.Cascade);
}

2. 优化实体创建与上下文添加逻辑 #

EF Core通过导航属性追踪关联实体，无需单独添加Researcher到上下文。修改RegisterUser方法：

public async Task<ServiceResponse<UserRegisterResponseDto>> RegisterUser(UserRegisterRequestDto request)
{
    List<string> userValidationMessages = ValidateUser(request);
    var serviceResponse = new ServiceResponse<UserRegisterResponseDto>();

    if (userValidationMessages.Count > 0)
    {
        serviceResponse.Success = false;
        serviceResponse.Messages = userValidationMessages;
        return serviceResponse;
    }

    string passwordHash = BCrypt.Net.BCrypt.HashPassword(request.Password);
    var user = new User
    {
        Email = request.Email,
        PasswordHash = passwordHash
    };

    // 建立双向引用
    var researcher = new Researcher
    {
        User = user,
        // 填充Researcher的其他必填属性
        FirstName = request.FirstName,
        LastName = request.LastName
    };
    user.Researcher = researcher;

    // 仅添加User，EF会自动关联添加Researcher
    _db.Users.Add(user);
    bool isSuccess = await _db.SaveChangesAsync() > 0;

    if (!isSuccess)
    {
        serviceResponse.Success = false;
        serviceResponse.Messages = new List<string> { "用户注册失败" };
        return serviceResponse;
    }

    serviceResponse.Success = true;
    serviceResponse.Messages = new List<string> { "注册成功" };
    // 确保DTO正确映射导航属性
    serviceResponse.Data = new UserRegisterResponseDto
    {
        UserId = user.UserId,
        Email = user.Email,
        Researcher = new ResearcherDto
        {
            ResearcherId = researcher.ResearcherId,
            FirstName = researcher.FirstName,
            LastName = researcher.LastName
            // 映射其他属性
        }
    };
   
    return serviceResponse;
}

3. 查询时确保加载导航属性 #

如果后续查询User时仍出现Researcher为空的情况，需使用Include方法显式加载导航属性：

var users = await _db.Users.Include(u => u.Researcher).ToListAsync();

4. 检查DTO映射逻辑 #

确认返回的UserRegisterResponseDto包含Researcher的对应字段，且映射逻辑正确（可使用AutoMapper等工具简化映射），避免遗漏导航属性的赋值。

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