C# lambda join two tables

    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
        });

Source: stackoverflow.com

Similar codes

1 vote267 views1 answer
What is type unity
C#Unity
5 votes286 views1 answer
F#
C#
1 vote219 views1 answer
Null check syntax c#
C#
0 vote282 views1 answer
Unity FPS camera z axis rotating problem
C#Unity
0 vote223 views2 answers
Dapper query list of parameters
C#
3 votes265 views2 answers
Unity create empty gameobject in code
C#Unity
3 votes231 views1 answer
Can you have multiple statement in a case c#
C#
14 votes246 views2 answers
How to make multiplayer game in unity
C#
1 vote281 views1 answer
How to open any file on button click in winforms
C#
0 vote253 views1 answer
Unity get rid of mouse
C#