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

9 votes202 views3 answers
Get rigidbody component unity
C#Unity
0 vote154 views1 answer
How can find github issue closed date
C#
0 vote145 views1 answer
Int if null put zero c#
C#
1 vote270 views2 answers
String to xml c#
C#
1 vote163 views2 answers
Unique items in list c#
C#
0 vote158 views1 answer
C# today without time
C#
0 vote153 views1 answer
C# remove first line from textbox
C#
0 vote193 views2 answers
C# list double min max
C#
0 vote158 views1 answer
Unity trigger not detecting collision
C#
0 vote167 views1 answer
New material unity
C#