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

6 votes201 views1 answer
Operator ++ c#
C#
0 vote226 views1 answer
Detect mouse in bottom of screen + unity
C#
1 vote210 views2 answers
No context type was found in the assembly 'AuthenticationApp'.
C#
0 vote226 views1 answer
How to assign 2d physics material through script
C#
0 vote173 views1 answer
Unity download image from web
C#
9 votes191 views3 answers
Find gameobject unity
C#Unity
26 votes225 views4 answers
Onkeypressed unity
C#
0 vote227 views1 answer
Map user to ConnectionId SignalR
C#
1 vote217 views1 answer
Int value from enum in C#
C#
0 vote215 views2 answers
Change canvas color uwp c#
C#