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 vote219 views1 answer
Unity particle system playing at the wrong location
C#
0 vote208 views1 answer
Clock in wpf
C#
2 votes240 views1 answer
Unity c# set object tag
C#Unity
1 vote226 views1 answer
C# winforms textbox text color
C#
0 vote250 views3 answers
Lista generica como parametro de un metodo en c#
C#
0 vote212 views1 answer
Aquarette
C#
9 votes203 views2 answers
Get last character of string c#
C#
1 vote205 views1 answer
Rigidbody.addtorque
C#
0 vote209 views1 answer
Count number of properties on an object C#
C#
1 vote229 views1 answer
Spawn coins randomli in the camera unity 2d
C#