score:47

Accepted answer

if i understand your questions correctly, all you need to do is add the .where(m => m.r.u.userid == 1):

    var userinrole = db.userprofiles.
        join(db.usersinroles, u => u.userid, uir => uir.userid,
        (u, uir) => new { u, uir }).
        join(db.roles, r => r.uir.roleid, ro => ro.roleid, (r, ro) => new { r, ro })
        .where(m => m.r.u.userid == 1)
        .select (m => new addusertorole
        {
            username = m.r.u.username,
            rolename = m.ro.rolename
        });

hope that helps.

score:4

i was looking for something and i found this post. i post this code that managed many-to-many relationships in case someone needs it.

    var userinrole = db.usersinroles.include(u => u.userprofile).include(u => u.roles)
    .select (m => new 
    {
        username = u.userprofile.username,
        rolename = u.roles.rolename
    });

Related Query

More Query from same tag