StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POLINQ recursive query to return hierarchical set of groups
text
Body
copied!<p>Given a list of the following models</p> <pre><code>public class Team { public int TeamId { get; set; } public int ParentTeamId { get; set; } } </code></pre> <p>I am trying to write a recursive linq query which will enable me to retrieve a heirarchy that looks like this</p> <pre><code>Team ChildTeams Team Team ChildTeams </code></pre> <p>I've tried many approaches and seen many similar questions but none of them specifically helped me solve the problem. The latest attempt I tried went along these lines:</p> <pre><code>private class TeamGrouping { public int? ParentTeamId { get; set; } public IEnumerable<Team> ChildTeams { get; set; } public IEnumerable<TeamGrouping> Grouping { get; set; } } private IEnumerable<TeamGrouping> ToGrouping(IEnumerable<Team> teams) { return teams.GroupBy(t => t.ParentTeamId, (parentTeam, childTeams) => new TeamGrouping {ParentTeamId = parentTeam, ChildTeams = childTeams}); } private IEnumerable<TeamGrouping> ToGrouping(IEnumerable<TeamGrouping> teams) { return teams.GroupBy(t => t.ParentTeamId, (parentTeam, childTeams) => new TeamGrouping{ParentTeamId = parentTeam, Grouping = childTeams}); } </code></pre> <p>I would pass the list of teams into the first <code>ToGrouping(IEnumerable<Team>)</code> and then subsequent returned groups into <code>ToGrouping(IEnumerable<TeamGrouping>)</code> but this is producing incorrect results.</p> <p>Anyone have any advice or ideas?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload