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

3 votes187 views4 answers
Sir W. Arthur Lewis
C#
0 vote178 views1 answer
Asp.net store list in web.config
C#
0 vote190 views1 answer
How to add rigidbody in unity
C#
5 votes192 views1 answer
Clone gameobject unity c#
C#Unity
1 vote170 views1 answer
Untiy delet ke
C#
0 vote188 views2 answers
Lcm of numbers
C#
0 vote155 views1 answer
How to get the position of a camera in unity
C#
0 vote183 views2 answers
C# check multiple variables for null
C#
0 vote209 views1 answer
Unity c# public all codes
C#Unity
0 vote174 views1 answer
Create a list of 3 Orders c#
C#