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

2 votes316 views1 answer
Net.core "a path base can only be configured using iapplicationbuilder.usepathbase()"
C#
0 vote325 views1 answer
Unity stop velocity movement
C#Unity
0 vote321 views1 answer
C# dapper execute stored procedure with parameters
C#
0 vote271 views1 answer
Swagger skip endpoint .net core
C#
0 vote314 views1 answer
Dotween dovalue
C#
0 vote292 views1 answer
C# loop xml
C#
0 vote365 views1 answer
Regex path pattern
C#
0 vote294 views1 answer
Get length of enum values
C#
2 votes300 views1 answer
How to copy a file in C#
C#
14 votes288 views2 answers
Play animation through script unity
C#