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

5 votes204 views6 answers
Shuffle array c#
C#
2 votes183 views1 answer
C# resize image keep aspect ratio
C#
0 vote214 views1 answer
How to make character respawn if touches sprite c#
C#
2 votes189 views1 answer
C# string format sepperate every thousand
C#
0 vote222 views1 answer
Unity Texture2D efficient performance draw pixels
C#
4 votes180 views1 answer
Find content of combo box index c#
C#
0 vote203 views1 answer
Get gameobject layermask
C#
0 vote196 views1 answer
Unity error log
C#
0 vote196 views3 answers
Assets\PlayerMovement.cs(5,44): error CS1003: Syntax error, ',' expected
C#
0 vote213 views1 answer
Ado stands for
C#