codefirst涉及到级联删除时可能会报下面的错误:
table 'TableName' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
此时可以在OnModelCreating方法中设置不创建级联删除约束(实际开发中需要我手动实现级联删除):
protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.Entity<Appointment>().HasRequired(a => a.Sponsor).WithMany(u => u.SpoAppointments).WillCascadeOnDelete(false); modelBuilder.Entity<Appointment>().HasRequired(a => a.Recipient).WithMany(u => u.RecAppointments).WillCascadeOnDelete(false); }
原文:http://blog.csdn.net/mx5721/article/details/44174399