實(shí)體框架代碼-來自同一表的兩個(gè)外鍵我剛開始使用EF代碼,所以我完全是這個(gè)話題的初學(xué)者。我想在球隊(duì)和比賽之間建立關(guān)系:1場(chǎng)比賽=2支球隊(duì)(主場(chǎng),客人)和結(jié)果。我認(rèn)為創(chuàng)建這樣的模型很容易,所以我開始編寫代碼:public class Team{
[Key]
public int TeamId { get; set;}
public string Name { get; set; }
public virtual ICollection<Match> Matches { get; set; }}public class Match{
[Key]
public int MatchId { get; set; }
[ForeignKey("HomeTeam"), Column(Order = 0)]
public int HomeTeamId { get; set; }
[ForeignKey("GuestTeam"), Column(Order = 1)]
public int GuestTeamId { get; set; }
public float HomePoints { get; set; }
public float GuestPoints { get; set; }
public DateTime Date { get; set; }
public virtual Team HomeTeam { get; set; }
public virtual Team GuestTeam { get; set; }}我得到了一個(gè)例外:引用關(guān)系將導(dǎo)致不允許的周期性引用。[約束名稱=Match_GuestTeam]
實(shí)體框架代碼-來自同一表的兩個(gè)外鍵
HUH函數(shù)
2019-06-25 13:22:59