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

3 votes186 views2 answers
C# get type of class
C#
2 votes200 views2 answers
Linq pick random element
C#
1 vote211 views1 answer
How do I print something in the console every frame unity
C#Unity
0 vote215 views2 answers
Datetime month name
C#
11 votes151 views1 answer
Unity waitforseconds
C#
2 votes193 views2 answers
C# matrix
C#
7 votes204 views2 answers
Unity mouse wheel
C#Unity
1 vote184 views1 answer
Float and int need help
C#
0 vote204 views1 answer
Windows forms tablelayoutpanel scroll
C#
0 vote185 views1 answer
C# xamarin forms use AssetManager to get text file
C#