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

0 vote96 views1 answer
How to do if statement based on date in asp net c#
C#
0 vote100 views1 answer
Is odd c# stackoverflow
C#
1 vote95 views1 answer
Unity foreach dictionary
C#
4 votes146 views10 answers
C++
C#
1 vote94 views1 answer
How to check type in c#
C#
5 votes104 views1 answer
C# or command
C#
0 vote103 views1 answer
C# radio button checked
C#
2 votes100 views1 answer
C# call main method
C#
0 vote105 views1 answer
C# how to start an application and detect if started
C#
0 vote99 views2 answers
.net return context.Result without extra new objectResult
C#