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 vote104 views4 answers
Reverses each word in the string c#
C#
1 vote114 views2 answers
C# assigning image location
C#
52 votes142 views6 answers
How to print something in c#
C#
0 vote137 views1 answer
C# new form
C#
2 votes185 views1 answer
How to remove space between string in c#
C#
0 vote125 views1 answer
C# return task list
C#
0 vote132 views1 answer
Print text c# unity
C#
24 votes122 views5 answers
Delete Directory
C#
2 votes137 views2 answers
Rotation unity script 2d
C#
3 votes132 views2 answers
Webclient c# example post
C#