LINQ query creates a StackOverflow Exception

Question

This is LINQ-to-SQL.

I'm trying to walk up a hierarchical relationship of SiteCategories to see how many levels there are.

int numLevels = 1;

//I tried setting this to new[] { parentID }.AsQueryable(); 
//but linq didn't like it
IQueryable<int> nextBatchOfParents = _catalogdb.SiteCategories
                    .Where(c => c.SiteCategoryId == parentID)
                    .Select(c => c.SiteCategoryId);

while ((nextBatchOfParents = _catalogdb.SiteCategoryRelationships
         .Where(rel => nextBatchOfParents.Any(x => x == rel.ChildSiteCategoryId))
         .Select(rel => rel.ParentSiteCategoryId)).Any())
                ++numLevels;

Unfortunately the first iteration of the loop causes a StackOverflow exception. I'm guessing I could sneak my way out of this by materializing most/all of these queries sooner, but I'm hoping there's a better way to fix this.

McKay · Accepted Answer · 2011-11-14 18:32:04Z

3

It looks like you're calling nextbatchofparents within itself.

answered Nov 14, 2011 at 18:32

McKay

12.7k7 gold badges58 silver badges81 bronze badges

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

2 Comments

Adam Rackis Over a year ago

Thank you. For some reason seeing you write that is what I needed. I feel silly now.

McKay Over a year ago

No problem, it happens all the time.

Collectives™ on Stack Overflow

LINQ query creates a StackOverflow Exception

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related