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

1 vote192 views3 answers
C# string to hex
C#
0 vote247 views1 answer
Type or namespace text could not be found unity
C#Unity
0 vote228 views1 answer
Process which converts natural sugar into alcohol by yeast
C#
2 votes251 views1 answer
Unity c# get direction of object
C#Unity
0 vote232 views1 answer
How-to-add-new-column-with-value-to-the-existing-datatable
C#
0 vote346 views1 answer
OpenBots convert Int to String
C#
1 vote202 views1 answer
C# loop through array of objet
C#
11 votes183 views1 answer
Abril modal boostrap
C#
0 vote182 views1 answer
C# Convert range
C#
1 vote178 views1 answer
Wpf label text color rgb string
C#