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

6 votes178 views1 answer
Entity framework Sql connection string for windows authentication
C#
0 vote191 views1 answer
Ef core index attribute
C#
0 vote184 views2 answers
List array
C#
5 votes201 views2 answers
C# break from foreach method
C#
0 vote181 views1 answer
Unity rigidbody2d disable
C#
0 vote186 views1 answer
Tecla intro en unity
C#
0 vote193 views1 answer
C# get all occurrences of a string
C#
0 vote215 views2 answers
C# sqrt
C#
1 vote205 views1 answer
How custom them of ckeditor
C#
2 votes167 views1 answer
Camera follow player unity smooth
C#