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

0 vote143 views1 answer
Clickable table row asp.net core
C#
1 vote129 views1 answer
How get piece of text in laravel in persian text
C#
7 votes144 views3 answers
C# run as administrator
C#
0 vote140 views2 answers
Streamwriter c#
C#
0 vote131 views1 answer
Display array elemetns to text box c#
C#
1 vote160 views1 answer
Strings in c#
C#
0 vote136 views1 answer
How to redirect to another page in button clicked in asp.net c# index.cshtml
C#
0 vote130 views1 answer
C# try catch with error message
C#
2 votes134 views2 answers
C sharp or operator in if statement
C#
2 votes139 views1 answer
Ef Select 2 from DB
C#