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 vote118 views1 answer
Vb.net open file with default program
C#
27 votes123 views3 answers
Basic movement script unity
C#Unity
0 vote113 views2 answers
Class merging
C#
0 vote122 views1 answer
C# mail retrieve library
C#
0 vote125 views1 answer
Blocked script execution in '<url>' because the document's frame is sandboxed and the 'allow-scripts' permission is not set.
C#
2 votes122 views1 answer
C# how to check if two lists have same values
C#
1 vote117 views1 answer
Shorthand in c# operator
C#
0 vote114 views1 answer
C# does value exist in list
C#
0 vote115 views1 answer
Defaultrequestheaders.authorization basic auth
C#
0 vote112 views1 answer
F# set function how to ignore duplicates
C#