Two Foreign Keys in entity framework for same table

Asked Aug 08 '12 at 10:14

Active Aug 08 '12 at 22:28

Viewed 423 times

I have two entities: Municipality and RoadSemgents. Municipality is parent and RoadSegments is a child table. I need to have two foreign Keys in RoadSegments from the same table (Municipality).

 public class Municipality
{
    [Key]
    public int ID { get; set; }
    public string Name { get; set; }
}


public class RoadSegments
{
    [Key]
    public int ID { get; set; }
    //ForeignKeys
    public int CodeMunicipalityLeft_ID { get; set; }
    public int CodeMunicipalityRight_ID { get; set; }

    [ForeignKey("CodeMunicipalityLeft_ID ")]
    public Municipality CodeMunicipalityLeft { get; set; }    // LOOK HERE 
    [ForeignKey("CodeMunicipalityRight_ID ")]
    public Municipality CodeMunicipalityRight { get; set; }   // AND HERE
}

How do I manage this situation? I have read some posts here for foreign keys to multiple tables but none worked for me.

edited Aug 08 '12 at 22:28

Holger Brandt

4,324
1
20
35

asked Aug 08 '12 at 10:14

Drill

1

Your question is not clear. Can you try to explain it in a more clear and concise way? – Matteo Mosca Aug 08 '12 at 10:30
And please, put here only the relevant code parts. – Marcelo De Zen Aug 08 '12 at 11:13
I'm not sure what the error / problem you are having but if you are using lazy loading you should mark the 2 Municpality as virtual. public virtual Municipality CodeMunicipalityLeft {get;set;} .... – Josh Aug 08 '12 at 13:43
Thank YOu for your answer. I`m not using Lazy Loading. I have disabled it. Problem is that the DB is never created. – Drill Aug 08 '12 at 14:42
1

Are you getting any exception whatsoever when running the application? – Anderson Fortaleza Aug 08 '12 at 19:34
What do you have in your OnModelCreating() method in your context class? – Brian Rogers Aug 08 '12 at 23:55

Two Foreign Keys in entity framework for same table

0 Answers0

Linked