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

23 votes174 views3 answers
C# format json
C#
2 votes141 views1 answer
How to insert into a list c#
C#
-2 votes215 views1 answer
Unity multiplayer Photon
C#Unity
0 vote148 views2 answers
Linq top selling products
C#
0 vote199 views1 answer
Unity Interstitial ad C#
C#Unity
0 vote159 views2 answers
C# To Pascal Case
C#
0 vote142 views2 answers
C# how to disable a event
C#
6 votes238 views2 answers
How to disable and enable rigidbody unity
C#Unity
0 vote159 views1 answer
Blazor swagger setup
C#
0 vote150 views1 answer
C# supplier equivalent
C#