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

0 vote251 views1 answer
Can lightning strike the same place twice
C#
0 vote215 views1 answer
Fill dataset with list c#
C#
0 vote223 views1 answer
Unity iterate all child objects
C#
0 vote191 views1 answer
Number to string ef example c#
C#
0 vote212 views1 answer
Dotnet core vue in subdirectory
C#
45 votes229 views6 answers
Iterate through dictionary c#
C#
3 votes209 views2 answers
Unity create empty gameobject in code
C#
1 vote204 views1 answer
Unity custom editor save changes
C#
0 vote216 views1 answer
No entity framework provider found for the ado.net provider with invariant name
C#
1 vote230 views1 answer
C# string contains any of list
C#