LINQ: 2 join with group by

var query = (
        //Customers
        from customer in context.Customers

        //Engineer 1
        join engineer1 in context.Employees on customer.PrimaryEngineer equals
        engineer1.EmployeeId into eng1 
        from engineer1 in eng1.DefaultIfEmpty()

        //Engineer Top
        join engineerTop in context.Employees on customer.TopEngineer equals 
        engineerTop.EmployeeId into top
        from engineerTop in top.DefaultIfEmpty()
        group new {customer, engineer1, engineerTop} by new {CustName = customer.Name, EmpId1 = engineer1.EmployeeId, EmpId2 = engineerTop.EmployeeId} into grp
        select new
        {
            Name = grp.Key.CustName,
            EmpId1 = grp.Key.EmpId1,
            EmpId2 = grp.Key.EmpId2
        });

Source: stackoverflow.com

Similar codes

4 votes165 views1 answer
How to write coroutine in unity
C#
0 vote261 views1 answer
Unity get perlin noise 3d
C#Unity
0 vote163 views1 answer
C# Program For Check Total Occurrence Of A Number In An Array
C#
25 votes209 views2 answers
Time delay C# unity
C#Unity
0 vote139 views1 answer
Ascii art american flag
C#
10 votes207 views4 answers
Unity rotate around point
C#Unity
6 votes214 views3 answers
Favicon png
C#
0 vote199 views1 answer
Username and password into base64 encoding c#
C#
0 vote154 views1 answer
How to store more precise data then float c#
C#
0 vote136 views1 answer
How to execute a code only once in update function in unity (cursed method)
C#