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 vote194 views1 answer
Unity dontdestroyonload
C#Unity
0 vote177 views1 answer
How to we put a link in button in a view in asp.net
C#
128 votes173 views11 answers
String to int c#
C#
0 vote167 views1 answer
Wpf textblock line break code behind
C#
0 vote235 views2 answers
C# webbrowser write html to text file
C#
1 vote184 views1 answer
Unity get script from gameobject
C#
4 votes336 views1 answer
Raycast from camera to mouse unity
C#
0 vote213 views1 answer
C# int array add number
C#
0 vote196 views1 answer
Convert from xls to xlsx C#
C#
36 votes167 views5 answers
C# string to byte array
C#