Relationship between tables in the Code First Entity Framework

Question

There is a class:

public class Match { [DataMember] public Guid Id { get; set; } [DataMember] public virtual Tour Tour { get; set; } [DataMember] public DateTime DateMatch { get; set; } [DataMember] public virtual Team Home { get; set; } [DataMember] public virtual Team Guest { get; set; } [DataMember] public virtual Result Result { get; set; } }

Where are the other classes that already exist in the database when adding:

Violation of PRIMARY KEY constraint 'PK_dbo.Teams'. Cannot insert duplicate key in object 'dbo.Teams'. The duplicate key value is (06f67648-f904-4a4e-8ceb-33c204d8267c). The statement has been terminated.

How to do not add a new command, but a link to an existing one?

Bald 4,638 3 23 63 · Answer 1 · 2016-07-16T14:36:36

Here is an example of how you can add two ForeignKey

 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; } }

for formatting code use Crtl+K , snippet is used for formatting Html / JS / CSS code

Relationship between tables in the Code First Entity Framework

1 answer 1

More articles: