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 vote125 views1 answer
C-sharp - get current page url/path/host
C#
0 vote126 views1 answer
.net directorysearcher get manager accountname
C#
1 vote132 views1 answer
Uuid generator asp.net
C#
0 vote130 views1 answer
Pyautogui not odwnloading
C#
0 vote129 views1 answer
C# write to lines without extra line
C#
1 vote129 views1 answer
C# copy file to system folder
C#
19 votes121 views4 answers
Get working directory c#
C#
0 vote137 views1 answer
1080 / 7
C#
0 vote128 views1 answer
Get connectionstring from web config c#
C#
6 votes132 views1 answer
C# read all text from a file
C#