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

5 votes164 views2 answers
Iso date format c#
C#
0 vote108 views1 answer
Unity exenerate
C#
0 vote110 views1 answer
Set property of control on form by name
C#
1 vote124 views1 answer
Coroutine not eaffected by time.timescale unity
C#Unity
0 vote146 views1 answer
C# int cast error
C#
0 vote72 views1 answer
Visibility bound to radio button wpf
C#
0 vote117 views1 answer
Httpcontext in .net standard
C#
0 vote109 views1 answer
Options Pattern how to use
C#
1 vote110 views1 answer
Photon rpc
C#
0 vote108 views1 answer
C# external execute batch
C#