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 vote145 views1 answer
Stringbuilder sb = new stringbuilder(reallylongstring); you need to identify whether a string stored in an object named stringtofind is within the stringbuilder sb object.
C#
1 vote148 views1 answer
Why vue cli do not refresh auto in local host
C#
1 vote132 views1 answer
Switch case c# contains
C#
11 votes147 views1 answer
How to edit text mesh pro text
C#
0 vote136 views1 answer
SQLite insert data in C# (Source:NAYCode.com)
C#
0 vote159 views1 answer
C# date type no time
C#
1 vote182 views1 answer
Unity string format time
C#
0 vote136 views2 answers
Xamarin Database insert in SQL Lite
C#
1 vote153 views1 answer
Best way to compare byte array c#
C#
34 votes148 views2 answers
Instantiate c#
C#