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 votes240 views1 answer
Unity how to get y value
C#Unity
0 vote182 views1 answer
Running C# Example
C#
1 vote237 views1 answer
C# check if string is path or file
C#
0 vote169 views1 answer
Qrcode c#
C#
1 vote176 views3 answers
Unity follow object
C#
0 vote170 views1 answer
Write last element of dictionary c#
C#
0 vote188 views1 answer
Can't select ui in scene view unity
C#
3 votes181 views1 answer
C# tinyiny
C#
0 vote142 views0 answer
C#
0 vote164 views1 answer
Init stirng list c#
C#