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 vote287 views1 answer
Access denied tring to save a file uwp xamarin
C#
35 votes188 views10 answers
C# initialize array
C#
29 votes263 views3 answers
Unity c# delay function
C#
1 vote268 views1 answer
Initialize ConsoleLoggerProvider in EF core
C#
1 vote290 views1 answer
How to make a specific scene load only on game start in unity
C#
0 vote312 views1 answer
Unity iap
C#Unity
0 vote306 views1 answer
Mvc invalidOperationException: Method 'InvokeAsync' of view component should be declared to return Task<t>
C#
25 votes267 views4 answers
Unity movetowards
C#
0 vote275 views1 answer
Php check syntax error folder
C#
1 vote328 views1 answer
Unity temperature to colour
C#Unity