iam working on asp.net mvc web application , entity framework. have following table:-
user table (userid,name,age, etc)
group table, (groupid,name,description,etc)
and usergroup table. (userid , groupid)
but since usergroup table pure many-to-many relationship stores both userid & groupid , not mapped using entity framework. know groupid , userid , how can populate relation between them. should such :-
group.where(a=.a.groupid).singleordefualt().user.add(//something here !!!)
var group = db.groups.find(groupid); if (group != null) { group.users.add(user); // add user existing users db.savechanges(); } or
user.groups.add(group); // add group existing groups db.savechanges(); if want replace users, assign new collection:
group.users = new list<user> { user }; db.savechanges(); if want remove user it's groups , add user other group:
var user = db.users.find(userid); user.groups.clear(); var group = db.groups.find(groupid); user.groups.add(group); db.savechanges(); if want remove users group:
var group = db.groups.find(groupid); // group var usertoremove = group.users.last(); // select user, e.g. last 1 group.users.remove(usertoremove); // remove user group users db.savechanges(); // save changes
Comments
Post a Comment