Build a model with 2 Foreign Keys to the Same Table

Question

Lets say I have a User model and now I want to add a Friend model. I want to name my FK fields RequestorID and ResponderID. What data annotations or fluent api mappings do I need to accomplish this and prevent EF from autogenerating its own columns?

public class Friend
{
    public int FriendID { get; set; }
    public int RequestorID { get; set; }
    public int ResponderID { get; set; }
    public int FriendStatusID { get; set; }
    public DateTime User1RequestDate { get; set; }
    public DateTime User2ResponseDate { get; set; }
    public virtual FriendStatus FriendStatus { get; set; }


    public virtual User Requestor { get; set; }
    public virtual User Responder { get; set; }

}

score 2 · Accepted Answer · edited Feb 19 '13 at 00:45

2

Try this

public class Friend
    {
        public int FriendID { get; set; }
        public int RequestorID { get; set; }
        public int ResponderID { get; set; }
        public int FriendStatusID { get; set; }
        public DateTime User1RequestDate { get; set; }
        public DateTime User2ResponseDate { get; set; }
        public virtual FriendStatus FriendStatus { get; set; }

        [ForeignKey("RequestorID")] //fixed
        public virtual User Requestor { get; set; }
        [ForeignKey("ResponderID")]
        public virtual User Responder { get; set; }
    }

edited Feb 19 '13 at 00:45

Jed Grant

1,305
1
17
47

answered Feb 18 '13 at 22:51

WannaCSharp

1,898
2
13
19

You have a syntax error on the first data annotation, but that worked. Thanks. – Jed Grant Feb 18 '13 at 23:24

Build a model with 2 Foreign Keys to the Same Table

1 Answers1