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 vote111 views1 answer
Pass list by ref c#
C#
0 vote111 views1 answer
C# read all lines from filestream
C#
5 votes114 views2 answers
Iso date format c#
C#
1 vote119 views1 answer
C# verify in class exist in list
C#
3 votes157 views1 answer
Unity get speed of object
C#Unity
1 vote145 views1 answer
Get string name of dropdown in unity
C#Unity
10 votes119 views6 answers
C# string to enum
C#
0 vote180 views1 answer
Unity customize hierarchy window
C#Unity
2 votes119 views2 answers
Unity get all components in gameobject
C#
0 vote129 views1 answer
Add qtwidgets to cmake file
C#