query nested objects with LINQ

Question

I have an instance object of Division class.

Division object holds a list of Branch objects.
Each branch object holds a list of Department objects.
Each Department object holds list of Team objects.

just to make it clear I can do that:

int MakeItClear = DivisionObject.ListOfBranches[5]
                                .ListOfDepartments[4]
                                .ListOfTeam[3]
                                .SomeIntegerProperty;

Each object has ID and Name properties

My wish is create a function that will return a list of team names by passing a parameter of Branch.ID using LINQ.

basically I want to do that using LINQ:

public static List<string> getBranchTeamNames(ref Sales.Division obj, int BranchID)
{
    List<string> result = new List<string>();
    foreach (Sales.Branch b in obj.allBranches)
    {
        if (b.branchID == BranchID)
        {
            foreach (Sales.Department d in b.allDepartmentsManagers)
            {
                foreach (Sales.Team t in d.allTeams)

                {
                    result.Add(t.teamName);
                }
            }

             break;
        }          
    }
    return result;
}

i will be happy for some guidance, does not matter if its c# or vb.net.

thank you for your time and consideration.

You want SelectMany

Toto
– Toto

2016-09-02 20:09:34 +00:00
Commented Sep 2, 2016 at 20:09 — Toto
– Toto, Commented Sep 2, 2016 at 20:09

Aashish Koirala · Accepted Answer · 2016-09-02 20:14:25Z

4

Try this:

return obj.allBranches
    .Where(x => x.branchID == BranchID)
    .SelectMany(x => x.allDepartmentsManagers)
    .SelectMany(x => x.allTeams)
    .Select(x => x.teamName)
    .ToList()

answered Sep 2, 2016 at 20:14

Aashish Koirala

4485 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

शेखर · Accepted Answer · 2023-01-06 04:56:59Z

0

You can use SelectMany

var teamNames = division.Branches.First(branch => 
branch.Id.Equals(branchId)).Departments.SelectMany(department => 
department.Teams.Select(team => team.Name));

edited Jan 6, 2023 at 4:56

शेखर

17.6k14 gold badges64 silver badges123 bronze badges

answered Sep 2, 2016 at 20:36

Juliano Souza

12 bronze badges

Collectives™ on Stack Overflow

query nested objects with LINQ

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related