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 vote377 views1 answer
Using == is inefficient unity
C#Unity
0 vote299 views1 answer
What is failure
C#
0 vote343 views1 answer
Join 2 list rows into one row and add totals fields C#
C#
1 vote354 views1 answer
How to use double in c#
C#
0 vote328 views1 answer
C# list keyvaluepair update value
C#
0 vote317 views1 answer
C# Case insensitive Contains(string)
C#
0 vote437 views1 answer
System.Collections.Generic.List`1[System.Int32] c# fix
C#
0 vote316 views1 answer
Top down movement unity
C#
0 vote308 views1 answer
C# enum to int array
C#
0 vote299 views1 answer
Afaik
C#