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 vote310 views1 answer
How to convert date to Complete ISO-8601 date in c#
C#
121 votes538 views6 answers
Generate a random number in c#
C#
0 vote312 views1 answer
How to post request C# with returning responsebody
C#
1 vote331 views1 answer
C# multiple button click event to password textbox
C#
0 vote321 views2 answers
How to get the index of an element in a list in unity 5
C#
1 vote331 views2 answers
Delegates in UnityC#
C#
0 vote327 views2 answers
_swapbatch.foreach multiple statements c#
C#
1 vote386 views1 answer
Unity gui text
C#Unity
0 vote378 views1 answer
Reflection assemblies gettypes
C#
0 vote330 views1 answer
C# MemoryStream - Timeouts are not supported on this stream
C#