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

2 votes254 views2 answers
Asp.net core url parameter
C#
6 votes212 views1 answer
How to generate entities from an existing database in entityframework core
C#
1 vote180 views2 answers
C# long to int
C#
-1 vote189 views1 answer
C# tuple
C#
0 vote185 views1 answer
If statement in razor using "?" and ":"
C#
0 vote179 views1 answer
Transformar de string a int c#
C#
0 vote205 views2 answers
Wpf yes no message box exit
C#
0 vote208 views1 answer
Unity deactivate scripts in list
C#
0 vote178 views2 answers
For c#
C#
1 vote249 views2 answers
Using (SqlDataReader sdr = cmd.ExecuteReader())
C#