外键映射到实体框架中的组合键
本文关键字:组合 框架 实体 映射 | 更新日期: 2023-09-27 17:49:36
尝试先与实体框架代码建立以下关系。下面的代码不工作,我已经尝试了很多变化…有人知道吗?
CONSTRAINT [FK_EVENT_Contact] FOREIGN KEY (Patient_ID,[Contact_ID]) REFERENCES
[PatientContact](Patient_ID,Person_ID)
public class PatientContact
{
[Key, Column(Order = 0)]
[DatabaseGenerated(DatabaseGeneratedOption.None)]
public int Person_ID { get; set; }
public virtual Person Person { get; set; }
[Key, Column(Order = 1)]
[DatabaseGenerated(DatabaseGeneratedOption.None)]
public int Patient_ID { get; set; }
public virtual Patient Patient { get; set; }
}
public class Event
{
[Key]
public int Event_ID { get; set; }
[Required]
public int EventType_ID {get;set;}
public virtual EventType EventType { get; set; }
[ForeignKey("Patient")]
public int Patient_ID { get; set; }
public virtual Patient Patient { get; set; }
[ForeignKey("PatientContact")]
public int Contact_ID { get; set; }
public virtual PatientContact PatientContact { get; set; }
}
你有两个选择。
尽量使用属性例如:
[ForeignKey("PatientContact"), Column(Order = 0)]
public int Person_ID{ get; set; }
[ForeignKey("PatientContact"), Column(Order = 1)]
public int Patient_ID{ get; set; }
public virtual PatientContact PatientContact { get; set; }
使用模型构建器(fluent api)
modelBuilder.Entity<Event>()
.HasRequired(p => p.PatientContact)
.WithMany()
.HasForeignKey(p => new {p.Person_ID, p.Patient_ID});