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

2 votes298 views2 answers
Ksi
C#
6 votes261 views1 answer
How to make mouse invisible unity
C#
0 vote299 views1 answer
How to reload app.config file at runtime in c#
C#
0 vote278 views1 answer
Call a .NET assembly from C or C++
C#
0 vote271 views1 answer
Anidate bucle in c#
C#
9 votes313 views3 answers
3d perlin noise unity
C#Unity
80 votes315 views4 answers
How to get random numbers in c#
C#
4 votes338 views1 answer
Deactivate a gameobject unity
C#Unity
0 vote303 views1 answer
Unity camera movement script
C#Unity
9 votes270 views1 answer
You have the following c# code. stringbuilder sb = new stringbuilder(really long string);
C#