CODEWITHSUNDEEP
c#linqlambdaaggregate-functions
Maya
Maya

Reputation: 1412

Aggregate duplicate members of an object in C# using LINQ / Lambda

I have a job to aggregate companies employees existing in 2 different databases using LINQ, the criteria is to find companies with the same name then find departments in these companies with the same name too then merge all employees into a new company object.

I have all companies from the 2 databases in one List<Company>, is their a way to use the Aggregate function to merge companies with the same name, then find departments with same name and merge all their employees? using the Aggregate function seems to be easy to merge "1 level" of data, I'm struggling to go into 3 levels of aggregation (Company>Department>Employee)

Example of my List<Company> AllCompanies object:

Company       Department      Employees   Source
-----------|--------------|-------------|---------
ABC Inc    |  Sales       | Sam         | DB1
           |              | Laura       |
-----------|--------------|-------------|---------
ABC Inc    |  Sales       | Joe         | DB2
-----------|--------------|-------------|---------
ABC Inc    |  Sales       | Joe         | DB1
-----------|--------------|-------------|---------
ABC Inc    |  IT          | Matt        | DB2
-----------|--------------|-------------|---------
XYZ Inc    |  Sales       | Steve       | DB1
-----------|--------------|-------------|---------
XYZ Inc    |  Sales       | Steve       | DB2 
-----------|--------------|-------------|---------
XYZ Inc    |  HR          | Mark        | DB2

I'm trying to convert the above to:

Company       Department      Employees
-----------|--------------|-------------
ABC Inc    |  Sales       | Sam
           |              | Laura
           |              | Joe
           |--------------|-------------
           |  IT          | Matt
-----------|--------------|-------------
XYZ Inc    |  Sales       | Steve
           |--------------|-------------
           |  HR          | Mark

For the sake of this example my match criteria is the name only.

Upvotes: 2

Views: 602

Answers (1)

Sergey Berezovskiy
Sergey Berezovskiy

Reputation: 236238

 from c in allCompanies
 group c by c.Company into departments
 select new {
    Company = departments.Key,
    Departments = from d in departments
                  group d by d.Department into employees
                  select new {
                      Department = employees.Key,
                      Employees = employees.Select(e => e.Employees)
                                           .Distinct()
                  }
 }

Upvotes: 4

Related Questions