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 vote243 views1 answer
Stateteach.net
C#
8 votes270 views2 answers
Asp.net core get request ip address
C#
0 vote271 views1 answer
C# list foreach lambda multiple actions
C#
0 vote274 views2 answers
C# string to uri
C#
-2 votes316 views1 answer
Random position unity 2d
C#Unity
0 vote265 views1 answer
Excel which style property define background color in c#
C#
1 vote283 views2 answers
Join Or Create Room() photon
C#
0 vote299 views1 answer
How to make character respawn if touches sprite c#
C#
0 vote263 views4 answers
Custom attribute for auth permission check .net
C#
0 vote270 views1 answer
C# trim trailing zero
C#