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 votes373 views1 answer
Load prefab in script unity
C#Unity
1 vote371 views1 answer
Change vignette intensity unity
C#Unity
7 votes343 views1 answer
For loop unity
C#
8 votes348 views1 answer
Unity get number of child objects
C#
1 vote435 views1 answer
'Camera' does not contain a definition for 'main'
C#
1 vote317 views2 answers
Linq unique count
C#
0 vote320 views1 answer
How to make pc bsod C#
C#
0 vote335 views1 answer
C# external execute batch
C#
31 votes330 views3 answers
Raycasting in unity
C#
4 votes385 views1 answer
Unity how to copy something to the clipboard
C#Unity