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

-2 votes235 views2 answers
How to get an arrays length in c#
C#
0 vote270 views2 answers
How to pass value to anothe form c# winform
C#
13 votes213 views2 answers
Lock mouse unity
C#Unity
0 vote228 views1 answer
.net mvc decimal displayformat currency
C#
2 votes260 views2 answers
Convert DateTime Format 04-08-2021 00:00:00 to string '08/04/2021' in C# c#
C#
-1 vote222 views1 answer
Populate combobox from array c#
C#
0 vote231 views1 answer
IEqualityComparer gethashcode strings c#
C#
0 vote227 views1 answer
Replace update claims c#
C#
0 vote222 views1 answer
.net core executenonqueryasync transaction
C#
0 vote260 views1 answer
How to download somthing from one drive unity
C#Unity