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 vote195 views1 answer
C# random color
C#
-1 vote181 views2 answers
Indexof c#
C#
0 vote201 views1 answer
Unity inspector draw line
C#Unity
0 vote187 views1 answer
Process.Start(osk.exe)
C#
2 votes139 views1 answer
Unity overlapsphere
C#Unity
0 vote184 views1 answer
Xamarin forms uwp button hover
C#
1 vote177 views1 answer
Return array in c#
C#
30 votes209 views3 answers
How to create a list in c# unity
C#Unity
0 vote175 views1 answer
How to create a class and objects in C#
C#
1 vote183 views2 answers
2d list c#
C#