在实体框架中更新数据库时,代码优先迁移,我遇到以下错误:
ALTER TABLE语句与外键约束"FK_dbo.Clients_dbo.MedicalGroups_MedicalGroupId"冲突.冲突发生在数据库"hrbc"、表"dbo.MedicalGroup"的"Id"列中.
这是我的班级:
public partial class Client
{
[Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int Id { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public int? MedicalGroupId { get; set; }
[ForeignKey("MedicalGroupId")]
public virtual MedicalGroups MedicalGroup { get { return _MedicalGroup; } set { _MedicalGroup = value; } }
}
这是我的第二节课:
public partial class MedicalGroups
{
[Key]
public int Id { get; set; }
public string Name { get; set; }
}
这是我要申请的移民:
public override void Up()
{
AddForeignKey("dbo.Clients", "MedicalGroupId", "dbo.MedicalGroups", "Id");
CreateIndex("dbo.Clients", "MedicalGroupId");
}