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 votes124 views2 answers
Rotation unity script 2d
C#
0 vote124 views1 answer
Set dirty a property unity custom inspector
C#
0 vote123 views4 answers
Read csv file into wpf C#
C#
1 vote141 views1 answer
Unity c# how to restart the level
C#Unity
6 votes147 views3 answers
Disable rigidbody unity
C#Unity
1 vote134 views1 answer
Renaming table name entity framework code first fluent api
C#
1 vote122 views1 answer
How to check if string can be converted to int c#
C#
1 vote124 views1 answer
System.Linq.IOrderedEnumerable`2[System.Char,System.Char] çözümü
C#
1 vote152 views1 answer
Unity change tag of go
C#Unity
3 votes115 views4 answers
C# get enum value from string
C#