在Entity Framework中为Booking的ICollection定义循环关联

我在项目中添加循环关联时遇到了问题：数据库里有一张Booking（特定机器预订）表，因为机器可同时处理多个预订，所以用另一张表存储所有重叠的并行预订。我想通过以下代码访问重叠预订：

var bookings = dbContext.Booking.Include(x => x.OverlapBookings).ToList();
foreach (var booking in bookings)
{
    var overlaps = booking.OverlapBookings;
    ...
}

但添加迁移时出现错误：

Unable to determine the relationship represented by navigation 'BookingDbModel.OverlapBookings' of type 'ICollection'. Either manually configure the relationship, or ignore this property using the '[NotMapped]' attribute or by using 'EntityTypeBuilder.Ignore' in 'OnModelCreating'.

相关实体类如下：
BookingDbModel：

public class BookingDbModel
{
    public int id { get; set; }
    public string Name { get; set; }
    public string Client { get; set; }
    public string Machine { get; set; }
    public DateTime StartTime { get; set; }
    public DateTime EndTime { get; set; }
    public ICollection<OverlapBookingDbModel> OverlapBookings { get; set; }
}

OverlapBookingDbModel：

public class OverlapBookingDbModel
{
    public int OriginalBookingId { get; set; }
    public BookingDbModel OriginalBooking { get; set; }
    public int TargetBookingId { get; set; }
    public BookingDbModel TargetBooking { get; set; }
}

这个问题是因为EF Core无法自动识别BookingDbModel与OverlapBookingDbModel之间的双向关联（Original和Target），需要手动配置关系。

方法一：使用数据注解 #

在BookingDbModel的导航属性上添加[InverseProperty]，明确指定关联的对应属性：

public class BookingDbModel
{
    public int id { get; set; }
    public string Name { get; set; }
    public string Client { get; set; }
    public string Machine { get; set; }
    public DateTime StartTime { get; set; }
    public DateTime EndTime { get; set; }

    // 指定该集合对应OverlapBookingDbModel中的OriginalBooking
    [InverseProperty(nameof(OverlapBookingDbModel.OriginalBooking))]
    public ICollection<OverlapBookingDbModel> OverlapBookings { get; set; }

    // 可选：添加集合存储当前预订作为Target的重叠记录
    [InverseProperty(nameof(OverlapBookingDbModel.TargetBooking))]
    public ICollection<OverlapBookingDbModel> AsTargetOverlaps { get; set; }
}

方法二：使用Fluent API（推荐） #

在DbContext的OnModelCreating方法中手动配置关联规则，同时设置复合主键：

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    // 给OverlapBookingDbModel设置复合主键，确保重叠记录唯一
    modelBuilder.Entity<OverlapBookingDbModel>()
        .HasKey(ob => new { ob.OriginalBookingId, ob.TargetBookingId });

    // 配置OriginalBooking与OverlapBookings的关联
    modelBuilder.Entity<OverlapBookingDbModel>()
        .HasOne(ob => ob.OriginalBooking)
        .WithMany(b => b.OverlapBookings)
        .HasForeignKey(ob => ob.OriginalBookingId)
        .OnDelete(DeleteBehavior.Restrict); // 避免级联删除引发循环错误

    // 配置TargetBooking的关联
    modelBuilder.Entity<OverlapBookingDbModel>()
        .HasOne(ob => ob.TargetBooking)
        // 如果需要从TargetBooking反向访问，替换为.WithMany(b => b.AsTargetOverlaps)
        .WithMany()
        .HasForeignKey(ob => ob.TargetBookingId)
        .OnDelete(DeleteBehavior.Restrict);
}

关键说明 #

1. OverlapBookingDbModel必须设置复合主键，因为一条重叠记录由OriginalBookingId和TargetBookingId共同唯一标识。
2. 设置OnDelete(DeleteBehavior.Restrict)是为了避免EF Core生成级联删除规则，防止删除预订时触发循环级联的错误。
3. 如果需要从某条预订中查看所有以它为目标的重叠记录，可在BookingDbModel中添加对应集合属性，并在Fluent API的.WithMany()中指定该属性。

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