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

26 votes182 views10 answers
For loop
C#
0 vote162 views1 answer
C# mysql select into datatable
C#
1 vote166 views1 answer
C# socket connect timeout
C#
0 vote154 views1 answer
How can find github issue closed date
C#
0 vote190 views1 answer
Convert C# Class to xml wth xsd.exe
C#
0 vote218 views1 answer
Download xml file asp.net web api
C#
0 vote303 views1 answer
C# create dynamic object
C#
0 vote150 views1 answer
Get all images from folder asp.net
C#
4 votes159 views3 answers
Httpclient post c# example
C#
0 vote171 views1 answer
Aws asp.net tutorial
C#