我正在尝试使用EF Core获取嵌套类别。问题是速度太慢。
看看我的代码:
public async Task<List<Category>> GetNestedCategoryAsync(Category category)
{
if (category is null)
return new List<Category>();
IQueryable<Category> query = db.Categories.Include(x => x.Childs).Include(x => x.Products).Where(x => category.Childs.Contains(x)).AsNoTracking();
List<Category> nestedCategories = await query.ToListAsync();
foreach (Category nestedCategory in nestedCategories.ToArray())
nestedCategories.AddRange(await GetNestedCategoryAsync(nestedCategory));
return nestedCategories;
}
实际上,我不知道如何将这个SQL翻译成EF。可能吗?它的速度快了千倍。
With Categories_CTE As
(
Select *
From Categories
Where Id = 8692
Union All
Select t.*
From Categories t
Inner Join Categories_CTE c On c.Id = t.ParentId
)
Select c.*
From Categories_CTE c;
感谢任何技巧