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

2 votes327 views1 answer
C# 2-dimensional array sort
C#
0 vote295 views1 answer
Unity onclick object
C#
1 vote319 views1 answer
Group by ef core
C#
0 vote319 views1 answer
Map user to ConnectionId SignalR
C#
9 votes330 views3 answers
Null coalescing operator c#
C#
4 votes320 views6 answers
Variables
C#
26 votes319 views3 answers
Print in c# unity
C#
0 vote310 views1 answer
C# get witdh of matrix
C#
0 vote321 views1 answer
String.QueryString c#
C#
0 vote305 views1 answer
C# pi
C#