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 vote184 views1 answer
Unity error creating asset at path
C#Unity
0 vote132 views1 answer
Give an alias in model .net
C#
0 vote136 views1 answer
Wpf keyboard press event
C#
0 vote137 views1 answer
Push vaiable in array c#
C#
-1 vote195 views1 answer
Unity public script
C#Unity
1 vote146 views1 answer
C# get next item in list
C#
1 vote134 views1 answer
Get values from range entity framework
C#
10 votes135 views1 answer
Change height of rect transform unity
C#
0 vote155 views1 answer
Qtablewidget add image
C#
0 vote233 views1 answer
Unity Rigidbody how to set zero momentum
C#Unity