EF多对多关系配置：删除实体时不级联删除关联对象报错排查

问题背景 #

之前功能正常，因模型大幅变更，删除所有迁移后重新构建数据库时出现问题。需求是：在EF的多对多关系中，删除User或Campaign实体时，不删除其关联的集合对象，但要自动移除中间表中的对应关联条目。

报错信息 #

执行Update-Database时触发以下错误：

SQL执行失败 #

Failed executing DbCommand (8ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
CREATE TABLE [CampaignUser] (
    [CampaignsId] int NOT NULL,
    [FollowersId] int NOT NULL,
    CONSTRAINT [PK_CampaignUser] PRIMARY KEY ([CampaignsId], [FollowersId]),
    CONSTRAINT [FK_CampaignUser_Campaigns_CampaignsId] FOREIGN KEY ([CampaignsId]) REFERENCES [Campaigns] ([Id]) ON DELETE CASCADE,
    CONSTRAINT [FK_CampaignUser_Users_FollowersId] FOREIGN KEY ([FollowersId]) REFERENCES [Users] ([Id]) ON DELETE CASCADE
);

约束冲突错误 #

Introducing FOREIGN KEY constraint 'FK_CampaignUser_Users_FollowersId' on table 'CampaignUser' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
Could not create constraint or index. See previous errors.

尝试的无效配置 #

用Fluent API配置时代码无法编译：

public class CampaignConfiguration : IEntityTypeConfiguration<Campaign>
{
    /// <inheritdoc />
    public void Configure(EntityTypeBuilder<Campaign> builder)
    {
        builder.HasMany(c => c.Followers)
            .WithMany(u => u.Campaigns).OnDelete()
    }
}

实体类定义 #

public class User
{
    public int Id { get; private set; }
    public ICollection<Campaign> Campaigns { get; set; }
}

public class Campaign
{
    public int Id { get; private set; }
    public ICollection<User> Followers { get; set; }
}

问题原因 #

1. SQL Server限制：SQL Server不允许同一张表的多个外键都设置ON DELETE CASCADE，否则会触发"循环/多路径级联"错误——EF Core默认会给多对多中间表的两个外键都加上CASCADE，这就违反了SQL Server的规则。
2. 语法错误：你尝试的Fluent API代码不完整，OnDelete()方法必须传入DeleteBehavior枚举值，不能空调用。

正确配置方案 #

要实现「删除实体时仅清理中间表关联、不删除关联对象」的需求，需要通过Fluent API显式配置中间表外键的删除行为，让EF Core在客户端处理中间表的关联清理，同时避免数据库端的双CASCADE冲突。

配置代码（EF Core 6+） #

public class CampaignConfiguration : IEntityTypeConfiguration<Campaign>
{
    public void Configure(EntityTypeBuilder<Campaign> builder)
    {
        builder.HasMany(c => c.Followers)
               .WithMany(u => u.Campaigns)
               .UsingEntity(
                   "CampaignUser", // 指定中间表名称（可选，EF会自动生成）
                   left => left.HasOne<User>()
                               .WithMany()
                               .HasForeignKey("FollowersId")
                               .OnDelete(DeleteBehavior.ClientCascade), // 客户端级联删除中间表记录
                   right => right.HasOne<Campaign>()
                                 .WithMany()
                                 .HasForeignKey("CampaignsId")
                                 .OnDelete(DeleteBehavior.ClientCascade),
                   join => join.HasKey("CampaignsId", "FollowersId") // 指定中间表复合主键
               );
    }
}

配置说明 #

• DeleteBehavior.ClientCascade：数据库端外键约束会设置为ON DELETE NO ACTION，由EF Core在客户端自动删除中间表中关联的条目，不会删除关联的User或Campaign实体。
• 若使用EF Core 5，需要显式指定中间表的字典类型（Dictionary<string, object>），写法如下：

builder.HasMany(c => c.Followers)
       .WithMany(u => u.Campaigns)
       .UsingEntity<Dictionary<string, object>>(
           "CampaignUser",
           l => l.HasOne<User>().WithMany().HasForeignKey("FollowersId").OnDelete(DeleteBehavior.ClientCascade),
           r => r.HasOne<Campaign>().WithMany().HasForeignKey("CampaignsId").OnDelete(DeleteBehavior.ClientCascade),
           j => j.HasKey("CampaignsId", "FollowersId"));

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