Question

I m trying to create a Friend relationship for my User table for my site. I m using MVC3 and EF4.1. Here is what I have so far (non-working). Any advice and suggestions is greatly appreciated! Thanks!

public class User{
    public int UserID {get;set;}
    public string Email {get;set;}
    public string Password {get;set;}

    public virtual ICollection<User> Buddies {get;set;}
}
/* mapping table for user to user friendships */
public class Friendship{
    public int UserID {get;set;}
    public int BuddyID {get;set;}
}

Answer 1

根据我对此的基本理解,我认为你的办法是好的。

不管怎么说,我将把它当作一个通用的数据库问题,而不是实体框架特有问题;网上应当有吨的材料。例如,here 你们可能有一些有益的东西。

希望这一帮助!

友情链接