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 vote151 views1 answer
C# webclient post file
C#
0 vote163 views2 answers
Create viewport revit api
C#
1 vote149 views2 answers
C# get first and last day of current month
C#
0 vote102 views1 answer
Canceltion token c#
C#
0 vote139 views1 answer
Html beginform
C#
27 votes159 views4 answers
Player movement script unity
C#
4 votes95 views2 answers
Append char to string c#
C#
1 vote143 views1 answer
C# socket connect timeout
C#
0 vote152 views1 answer
Unity normalize movement
C#
1 vote154 views1 answer
C# how to remove an image in a folder
C#