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 vote120 views3 answers
Loops in coding
C#
0 vote109 views1 answer
Ascx access parent master page
C#
0 vote96 views1 answer
C# set datetime to null value
C#
10 votes144 views1 answer
Change height of rect transform unity
C#Unity
3 votes125 views1 answer
Unity mouse scroll wheel axis
C#
7 votes103 views2 answers
Instantiate gameobject as child
C#
0 vote99 views1 answer
Query Parent-GrandChild single
C#
4 votes111 views1 answer
Unity ui change sprite
C#
0 vote99 views1 answer
SQLite insert data in C# (Source:NAYCode.com)
C#
3 votes110 views2 answers
Find sum of multiples of a number up to N
C#