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

21 votes236 views6 answers
Button group bootstrap
C#
18 votes179 views3 answers
C# decimal vs double
C#
0 vote248 views3 answers
Query string not ending with with vowels
C#
2 votes179 views1 answer
Unity deactivate all colliders of a gameobject
C#
1 vote183 views1 answer
Unity temperature to colour
C#
0 vote222 views2 answers
F# tuple get item
C#
0 vote172 views1 answer
Pyqt send message to another instance
C#
0 vote183 views1 answer
C# Jobject to string
C#
0 vote184 views7 answers
Python to php converter online
C#
11 votes179 views2 answers
C# messagebox result
C#