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

1 vote126 views1 answer
Unity main texture not working
C#
57 votes219 views6 answers
Unity find objects with tag
C#
0 vote123 views1 answer
C# try catch with error message
C#
0 vote128 views1 answer
C# console create window
C#
1 vote122 views1 answer
Null check syntax c#
C#
1 vote140 views2 answers
Using (SqlDataReader sdr = cmd.ExecuteReader())
C#
7 votes130 views1 answer
Count number of enum values C#
C#
0 vote82 views1 answer
Console.readline not working
C#
2 votes142 views1 answer
C# minus days from datetime
C#
0 vote132 views1 answer
Don't want to update revision while updating field by code in sitecore c#
C#