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 vote317 views1 answer
Converting alpha1 into int unity
C#Unity
0 vote133 views1 answer
Translate nicely between two vector3
C#
10 votes190 views3 answers
Unity C# instantiate prefab
C#Unity
0 vote148 views1 answer
Return stream from file c#
C#
1 vote136 views1 answer
C# zeitverzögerung
C#
0 vote158 views1 answer
Embed video to exe file with c#
C#
3 votes162 views1 answer
Change the text of inputfield unity
C#Unity
18 votes155 views4 answers
C# messagebox yes no
C#
0 vote245 views1 answer
HttpClient .net Core add Certificate
C#
1 vote132 views3 answers
Boolean in c#
C#