Horje
LINQ: 2 join with group by Code Example
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
        });




Csharp

Related
remove header visual studio android Code Example remove header visual studio android Code Example
how to check type c# Code Example how to check type c# Code Example
trygetvalue dictionary c# example Code Example trygetvalue dictionary c# example Code Example
how to uncheck a radio button in c# Code Example how to uncheck a radio button in c# Code Example
how to add item in list at first position c# Code Example how to add item in list at first position c# Code Example

Type:
Code Example
Category:
Coding
Sub Category:
Code Example
Uploaded by:
Admin
Views:
10