LINQ中实现对象Many-To-Many(多对多)的关系映射

前段时间,大概用了一下LINQ to SQL, 发觉O/Rdesigner似乎没有Many-To-Many(多对多)关系的支持,只有自己写代码实现.
:(

提供一下俺的解决办法:
例如User和UserGroup的关系,假设保存在UserInGroups表中,这里记录了User和Group的对应关系,那么,需要手动在User/Group类中添加对应的partial属性:

public partial class User{ 

     <> Groups 

    { 

         groups =  g in db.UserInGroups 

                            where g.UserId = this.UserId 

                             {g.Groups}; 

        return groups; 

    } 

}

public partial class Group{ 

     <> Users 

    { 

         users =  u in db.UserInGroups 

                            where u.GroupId = this.GroupId 

                             {u.Users}; 

        return users; 

    } 

}

转载于:https://www.cnblogs.com/xzwplus/archive/2007/12/27/1017350.html