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

1 vote175 views2 answers
System.data.sqlclient.sqlexception
C#
0 vote180 views1 answer
Validating file upload asp.net core mvc
C#
0 vote182 views1 answer
Zoom gedit
C#
1 vote158 views1 answer
Unity 2d player move
C#
0 vote276 views1 answer
Unity add explosion force
C#Unity
1 vote168 views1 answer
C# unity detect any keyboard input but not mouse input
C#
1 vote171 views3 answers
Byte[] to base 65 string in C#
C#
0 vote176 views1 answer
Textbox gotfocus wpf
C#
0 vote172 views2 answers
C# read large file
C#
-1 vote231 views1 answer
Center mouse unity
C#Unity