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 vote168 views1 answer
C# iorderedenumerable to dictionary
C#
0 vote189 views1 answer
Unity rb.addexplosionforce 2d
C#
4 votes262 views1 answer
Unity get animator
C#Unity
4 votes192 views2 answers
Wpf label text in center
C#
1 vote181 views1 answer
How to check a list is null or empty in c#
C#
0 vote280 views1 answer
Unity switch to scene and transfer data
C#Unity
4 votes207 views2 answers
Unity clamp rotation
C#
0 vote176 views1 answer
Microsoft forms create bitmap
C#
0 vote193 views1 answer
C# entity framework get all records from table
C#
0 vote176 views1 answer
How to convert c# string to pdf
C#