ASP.NET Core 6 MVC+EF Core表间外键循环引用问题求助

在基于ASP.NET Core 6和Entity Framework Core开发的学校管理系统项目中，涉及10张表，因表间关联关系问题导致迁移失败。此前已按建议修改部分代码，但出现新问题，无法自行解决。

项目模型代码 #

public class Classe
{
    [Key]
    public int Id { get; set; }
    public string ClassName { get; set; }
    public ICollection<Examen> Examens { get; set; }
    public ICollection<Subject> Subjects { get; set; }
    public ICollection<Student> Students { get; set; }
    public ICollection<TeacherSubject> TeacherSubjects { get; set; }
    public ICollection<Expense> Expenses { get; set; }
    public ICollection<Fee> Fees { get; set; }
    public ICollection<StudentAttendence> StudentAttendence { get; set; }
}

public class Examen
{
    [Key]
    public int Id { get; set; }
    public string Name { get; set; }
    public int Marks { get; set; }

    public virtual Classe Classe { get; set; }
    [ForeignKey(nameof(Classe))]
    public int ClasseId { get; set; }

    public virtual Subject Subject { get; set; }
    [ForeignKey(nameof(Subject))]
    public int SubjectId { get; set; }
}

public class Expense
{
    public int Id { get; set; }
    public int ChargeAmount { get; set; }

    public virtual Classe Classe { get; set; }
    [ForeignKey(nameof(Classe))]
    public int ClasseId { get; set; }

    public virtual Subject Subject { get; set; }
    [ForeignKey(nameof(Subject))]
    public int SubjectId { get; set; }
}

public class Fee
{
    public int Id { get; set; }
    public int FeeAmount { get; set; }

    public virtual Classe Classe { get; set; }
    [ForeignKey(nameof(Classe))]
    public int ClasseId { get; set; }
}

public class Student
{
    public int Id { get; set; }
    public string FirstName { get; set; }
    public string LastName { get; set; }
    public DateTime DOB { get; set; }
    public string Gender { get; set; }
    public string Mobile { get; set; }
    public string RollNo { get; set; }
    public string Adresse { get; set; }

    public virtual Classe Classe { get; set; }
    [ForeignKey(nameof(Classe))]
    public int ClasseId { get; set; }
}

public class StudentAttendence
{
    public int Id { get; set; }
    public string RollNo { get; set; }
    public byte Status { get; set; }
    public DateTime date { get; set; }

    public virtual Classe Classe { get; set; }
    [ForeignKey(nameof(Classe))]
    public int ClasseId { get; set; }

    public virtual Subject Subject { get; set; }
    [ForeignKey(nameof(Subject))]
    public int SubjectId { get; set; }
}

public class Subject
{
    public int Id { get; set; }
    public string SubjectName { get; set; }
    public ICollection<Examen> Examens { get; set; }
    public ICollection<TeacherSubject> TeacherSubjects { get; set; }
    public ICollection<Expense> Expenses { get; set; }
    public ICollection<StudentAttendence> StudentAttendence { get; set; }

    public virtual Classe Classe { get; set; }
    [ForeignKey(nameof(Classe))]
    public int ClasseId { get; set; }
}

public class Teacher
{
    public int Id { get; set; }
    public string FirstName { get; set; }
    public string LastName { get; set; }
    public DateTime DOB { get; set; }
    public string Gender { get; set; }
    public string Mobile { get; set; }
    public string Email { get; set; }
    public string Adresse { get; set; }
    public string PassWord { get; set; }
    public ICollection<TeacherSubject> TeacherSubjects { get; set; }
    public ICollection<TeacherAttendence> TeacherAttendence { get; set; }
}

public class TeacherAttendence
{
    public int Id { get; set; }
    public byte Status { get; set; }
    public DateTime date { get; set; }

    public virtual Teacher Teacher { get; set; }
    [ForeignKey(nameof(Teacher))]
    public int TeacherId { get; set; }
}

public class TeacherSubject
{
    public int Id { get; set; }

    public virtual Classe Classe { get; set; }
    [ForeignKey(nameof(Classe))]
    public int ClasseId { get; set; }

    public virtual Subject Subject { get; set; }
    [ForeignKey(nameof(Subject))]
    public int SubjectId { get; set; }

    public virtual Teacher Teacher { get; set; }
    [ForeignKey(nameof(Teacher))]
    public int TeacherId { get; set; }
}

DbContext代码 #

public class SchoolContext : DbContext
{
    public SchoolContext(DbContextOptions<SchoolContext> options):base(options)
    {
    }

    public DbSet<Classe> Classes { get; set; }
    public DbSet<Examen> Examens { get; set; }
    public DbSet<Subject> Subjects { get; set; }
    public DbSet<Student> Students { get; set; }
    public DbSet<Teacher> Teachers { get; set; }
    public DbSet<TeacherSubject> TeacherSubjects { get; set; }
    public DbSet<Expense> Expenses { get; set; }

    public DbSet<Fee> Fees { get; set; }
    public DbSet<StudentAttendence> StudentAttendences { get; set; }
    public DbSet<TeacherAttendence> TeacherAttendences { get; set; }
}

迁移错误信息 #

Introducing a FOREIGN KEY constraint 'FK_Examens_Subjects_SubjectId' on the 'Exams' table may cause cycles or multiple cascad accesses. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
Unable to create constraint or index.

问题原因及解决方法 #

原因分析 #

错误源于循环级联删除：Subject依赖Classe，而Examen同时依赖Classe和Subject。当删除Classe时，EF默认的级联删除会同时触发对Subject和Examen的删除操作，但Examen又关联Subject，形成循环依赖，导致数据库无法创建约束。

解决方法 #

方法1：配置级联删除行为为NoAction

在SchoolContext中重写OnModelCreating方法，手动配置相关外键的删除行为，避免循环级联：

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    // 配置Examen与Subject的外键，删除时不级联
    modelBuilder.Entity<Examen>()
        .HasOne(e => e.Subject)
        .WithMany(s => s.Examens)
        .OnDelete(DeleteBehavior.NoAction);

    // 配置Expense与Subject的外键，删除时不级联
    modelBuilder.Entity<Expense>()
        .HasOne(e => e.Subject)
        .WithMany(s => s.Expenses)
        .OnDelete(DeleteBehavior.NoAction);

    // 配置StudentAttendence与Subject的外键，删除时不级联
    modelBuilder.Entity<StudentAttendence>()
        .HasOne(sa => sa.Subject)
        .WithMany(s => s.StudentAttendence)
        .OnDelete(DeleteBehavior.NoAction);
}

方法2：优化关联结构，移除冗余外键

由于Subject已经属于某个Classe，Examen、Expense、StudentAttendence无需直接关联Classe，可通过Subject间接关联，从根源上消除循环：

• 修改Examen类，移除Classe导航属性和ClasseId：

public class Examen
{
    [Key]
    public int Id { get; set; }
    public string Name { get; set; }
    public int Marks { get; set; }

    public virtual Subject Subject { get; set; }
    [ForeignKey(nameof(Subject))]
    public int SubjectId { get; set; }
}

• 同理，修改Expense和StudentAttendence类，移除Classe相关属性：

// 修改后的Expense
public class Expense
{
    public int Id { get; set; }
    public int ChargeAmount { get; set; }

    public virtual Subject Subject { get; set; }
    [ForeignKey(nameof(Subject))]
    public int SubjectId { get; set; }
}

// 修改后的StudentAttendence
public class StudentAttendence
{
    public int Id { get; set; }
    public string RollNo { get; set; }
    public byte Status { get; set; }
    public DateTime date { get; set; }

    public virtual Subject Subject { get; set; }
    [ForeignKey(nameof(Subject))]
    public int SubjectId { get; set; }
}

• 同时更新Classe类中的集合属性，移除对应的关联：

public class Classe
{
    [Key]
    public int Id { get; set; }
    public string ClassName { get; set; }
    public ICollection<Subject> Subjects { get; set; }
    public ICollection<Student> Students { get; set; }
    public ICollection<TeacherSubject> TeacherSubjects { get; set; }
    public ICollection<Fee> Fees { get; set; }
}

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