EF Core 6自引用多对多实体关联异常问题求助

1. 实体导航属性配置缺失或混淆 #

自引用多对多关系必须明确区分包含方和被包含方的反向导航属性，否则EF无法识别关系两端，导致外键赋值错误。

正确的实体定义示例：

public class PublicHolidayCalendar
{
    public int Id { get; set; }
    // 其他业务属性...

    // 当前日历包含的子日历关联集合
    public ICollection<PublicHolidayCalendarInclusion> IncludedCalendars { get; set; }
    // 包含当前日历的父日历关联集合
    public ICollection<PublicHolidayCalendarInclusion> ParentCalendars { get; set; }
}

public class PublicHolidayCalendarInclusion
{
    // 包含方（父日历）ID
    public int IncludedInCalendarId { get; set; }
    public PublicHolidayCalendar IncludedInCalendar { get; set; }

    // 被包含方（子日历）ID
    public int IncludedCalendarId { get; set; }
    public PublicHolidayCalendar IncludedCalendar { get; set; }
}

2. Fluent API关系配置未明确区分两端 #

必须在DbContext的OnModelCreating中显式绑定导航属性与外键的对应关系，避免EF自动映射出错：

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    // 设置中间表复合主键
    modelBuilder.Entity<PublicHolidayCalendarInclusion>()
        .HasKey(i => new { i.IncludedInCalendarId, i.IncludedCalendarId });

    // 绑定父日历与中间表的关系
    modelBuilder.Entity<PublicHolidayCalendarInclusion>()
        .HasOne(i => i.IncludedInCalendar)
        .WithMany(c => c.IncludedCalendars)
        .HasForeignKey(i => i.IncludedInCalendarId)
        .OnDelete(DeleteBehavior.Restrict); // 自引用场景禁用级联删除，避免循环

    // 绑定子日历与中间表的关系
    modelBuilder.Entity<PublicHolidayCalendarInclusion>()
        .HasOne(i => i.IncludedCalendar)
        .WithMany(c => c.ParentCalendars)
        .HasForeignKey(i => i.IncludedCalendarId)
        .OnDelete(DeleteBehavior.Restrict);
}

3. AddIncludedCalendar方法逻辑错误 #

检查添加关联的方法是否错误地将同一个实例同时赋值给两端：

错误示例： #

public void AddIncludedCalendar(PublicHolidayCalendar calendar)
{
    var inclusion = new PublicHolidayCalendarInclusion
    {
        IncludedInCalendar = this,
        IncludedCalendar = this // 错误：被包含日历应该传入目标实例，而非当前实例
    };
    IncludedCalendars.Add(inclusion);
}

正确示例： #

public void AddIncludedCalendar(PublicHolidayCalendar targetCalendar)
{
    if (targetCalendar == null || targetCalendar.Id == this.Id)
        return; // 避免自引用无效关联

    var inclusion = new PublicHolidayCalendarInclusion
    {
        IncludedInCalendar = this, // 当前实例作为包含方
        IncludedCalendar = targetCalendar // 传入的实例作为被包含方
    };
    IncludedCalendars.Add(inclusion);
}

4. 实体状态未被上下文正确跟踪 #

如果被包含的日历实例是脱离上下文的（比如从外部传入的未跟踪对象），EF无法正确获取其ID值。添加关联前需确保实例被上下文跟踪，可通过context.Attach(targetCalendar)将其附加到上下文。

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