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 vote342 views1 answer
Two question marks together mean in C#
C#
5 votes362 views3 answers
Unix time c#
C#
0 vote288 views4 answers
Reverses each word in the string c#
C#
0 vote354 views1 answer
Ocr library for c#
C#
7 votes358 views2 answers
Unity how to create a prefab
C#Unity
0 vote329 views1 answer
Decimal in .asp.net core
C#
3 votes350 views3 answers
Rigidbody2d unity
C#Unity
5 votes338 views4 answers
Linq foreach c#
C#
9 votes374 views3 answers
3d perlin noise unity
C#Unity
2 votes357 views1 answer
How to restart flutter app programmatically
C#