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

39 votes145 views1 answer
C sharp split string
C#
0 vote133 views1 answer
Unity convert number to notation
C#
1 vote152 views1 answer
How to store an array inside an array c#
C#
1 vote154 views2 answers
C# memorystream to byte array
C#
0 vote159 views1 answer
Create stripe subscription pay_immediately
C#
0 vote148 views1 answer
All SQL Server Tables in a Schema
C#
4 votes98 views1 answer
C# get month name
C#
1 vote144 views1 answer
Asking for user input integer c#
C#
0 vote160 views1 answer
Create entity c# d365
C#
3 votes136 views4 answers
C# get enum value from string
C#