数据迁移add-migration update-database错误:
将 FOREIGN KEY 约束 'FK_T_OrgUnits_T_OrgUnits_ParentId' 引入表 'T_OrgUnits' 可能会导致循环或多重级联路径。请指定 ON DELETE NO ACTION 或 ON UPDATE NO ACTION,或修改其他 FOREIGN KEY 约束。
无法创建约束或索引。请参阅前面的错误。
public class OrgUnit
{
public long Id { get; set; }
public string Name { get; set; }
public OrgUnit Parent { get; set; }
public List<OrgUnit> Children { get; set; }= new List<OrgUnit>();
}
public class OrgUnitConfig : IEntityTypeConfiguration<OrgUnit>
{
void IEntityTypeConfiguration<OrgUnit>.Configure(EntityTypeBuilder<OrgUnit> builder)
{
builder.ToTable("T_OrgUnits");
builder.Property(o => o.Name).IsRequired().IsUnicode().HasMaxLength(100);
builder.HasOne<OrgUnit>(u => u.Parent).WithMany(p => p.Children);
}
}