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 vote260 views1 answer
C# restclient timeout
C#
0 vote279 views2 answers
Wpf button to return to last window
C#
0 vote286 views1 answer
Trygetvalue dictionary c# example
C#
11 votes316 views3 answers
C# return two values
C#
27 votes279 views6 answers
Stack over flow
C#
0 vote288 views1 answer
GetNetworkTime
C#
0 vote277 views1 answer
.net core login redirect loop
C#
0 vote273 views1 answer
C # c^b
C#
1 vote283 views2 answers
C# listview add item
C#
-1 vote266 views6 answers
Automatic time complexity Calculator
C#