如何在EF Core中配置带独立导航属性的双一对一关联？

实体结构 #

Subject            Owner
-------            ----
SubjectId: int     OwnerId: int
OwnerId: int?      Name: string
CoOwnerId: int?    ====
=======            Subject: Subject
Owner: Owner
CoOwner: Owner

尝试的配置及错误 #

尝试通过OnModelCreatingPartial配置两个一对一关联时触发报错：

partial void OnModelCreatingPartial(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<Owner>()
        .HasOne(o => o.Subject)
        .WithOne(s => s.Owner)
        .HasForeignKey<Subject>(s => s.OwnerId);

    modelBuilder.Entity<Owner>()
        .HasOne(o => o.Subject)
        .WithOne(s => s.CoOwner)
        .HasForeignKey<Subject>(s => s.CoOwnerId);
}

错误提示：

无法创建'Owner.Subject'与'Subject.CoOwner'之间的关联，因为'Owner.Subject'与'Subject.Owner'之间已存在关联。导航属性只能参与单个关联。若要覆盖现有关联，请先在'OnModelCreating'中对导航属性'Subject.CoOwner'调用'Ignore'。

查询行为异常 #

仅保留单关联配置时，查询Subject的所有者关联正常，但查询Owner作为CoOwner时，Subject导航属性返回null：

// 正常：Subject正确关联Owner和CoOwner
ctx.Subjects
    .Include(s => s.Owner)
    .Include(s => s.CoOwner)
    .Where(s => s.CoOwnerId == 2)
    .Single();
// 返回结果：{ Owner: {1}, CoOwner: {2} }

// 正常：Owner作为主所有者时能关联Subject
ctx.Owners
    .Include(o => o.Subject)
    .Single(o => o.OwnerId == 1);
// 返回结果：{ Subject: { Owner: {1}, CoOwner: {2} } }

// 异常：Owner作为CoOwner时Subject为null
ctx.Owners
    .Include(o => o.Subject)
    .Single(o => o.OwnerId == 2);
// 返回结果：{ Subject: null }

// 基于CoOwner的过滤查询正常工作
ctx.Subjects.Where(s => s.Owner.Name == "John"); // 正常执行
ctx.Subjects.Where(s => s.CoOwner.Name == "Joe"); // 正常执行

解决方案：拆分Owner的导航属性 #

问题核心是单个导航属性无法同时绑定两个关联关系，EF Core要求每个导航属性仅属于一个关联。需修改Owner实体，新增两个导航属性分别对应主所有者和CoOwner的关联：

1. 更新Owner实体 #

public class Owner
{
    public int OwnerId { get; set; }
    public string Name { get; set; }

    // 新增导航：对应作为主所有者关联的Subject
    public Subject OwnedSubject { get; set; }
    // 新增导航：对应作为CoOwner关联的Subject
    public Subject CoOwnedSubject { get; set; }
}

2. 配置关联关系 #

在OnModelCreatingPartial中分别配置两个一对一关联：

partial void OnModelCreatingPartial(ModelBuilder modelBuilder)
{
    // 主所有者关联：Owner.OwnedSubject ↔ Subject.Owner
    modelBuilder.Entity<Owner>()
        .HasOne(o => o.OwnedSubject)
        .WithOne(s => s.Owner)
        .HasForeignKey<Subject>(s => s.OwnerId);

    // CoOwner关联：Owner.CoOwnedSubject ↔ Subject.CoOwner
    modelBuilder.Entity<Owner>()
        .HasOne(o => o.CoOwnedSubject)
        .WithOne(s => s.CoOwner)
        .HasForeignKey<Subject>(s => s.CoOwnerId);
}

3. 查询调整 #

查询Owner时，需根据角色选择对应的导航属性：

// 查询作为主所有者的Owner及其Subject
ctx.Owners
    .Include(o => o.OwnedSubject)
    .Single(o => o.OwnerId == 1);

// 查询作为CoOwner的Owner及其Subject
ctx.Owners
    .Include(o => o.CoOwnedSubject)
    .Single(o => o.OwnerId == 2);

如果需要统一获取Owner关联的Subject，可添加无映射的计算属性：

public class Owner
{
    // ... 原有属性及导航 ...

    [NotMapped]
    public Subject Subject => OwnedSubject ?? CoOwnedSubject;
}

此后直接访问Owner.Subject即可获取对应的关联对象。

原理说明 #

EF Core中每个导航属性只能隶属于一个关联关系，原配置试图用Owner.Subject同时绑定两个关联，违反了这一规则。通过拆分导航属性，让每个关联对应独立的导航，就能正确建立双向映射。

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