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

0 vote259 views1 answer
How to we put a link in button in a view in asp.net
C#
3 votes276 views2 answers
Unity how to add force
C#Unity
0 vote327 views1 answer
Visual studio pre build event not working
C#
2 votes274 views1 answer
Placeholder syntax c#
C#
0 vote256 views1 answer
Mvc c# return renderPartial
C#
1 vote279 views2 answers
List.max c#
C#
2 votes280 views1 answer
How to pause physics in unity c#
C#Unity
2 votes283 views2 answers
How to rotate object in unity only on one axis
C#
1 vote238 views1 answer
Xamarin picker item
C#
0 vote220 views1 answer
Link list in c#
C#