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 vote173 views1 answer
Spawning object around in a circle of an gameobject unity'
C#
2 votes209 views1 answer
Set object to random color unity
C#Unity
0 vote171 views1 answer
Unity c# image invisible
C#
0 vote169 views1 answer
1080 / 7
C#
0 vote164 views1 answer
RemoveClaim
C#
1 vote162 views1 answer
Blank background for button wpf
C#
3 votes163 views1 answer
Linq include
C#
0 vote174 views1 answer
.net core copy file in folder to root
C#
0 vote170 views1 answer
C# get all occurrences of a string
C#
0 vote170 views1 answer
The name scripts does not exist in the current context mvc 5
C#