Linq返回筛选的孩子 [英] Linq Return Filtered Children

问题描述

我有一个'唔'的时刻，这似乎应该是直线前进，但我似乎无法做到。我有一个简单的集合：

 类别名称
 --->列表与LT;分类> （这个类的子类）
  

我希望用户能够基于Category.Name进行过滤维护层次结构。所以例如。

 我的类别
 ---> Category.Name，ABC
 ---> Category.Name，123
 --->如果用户键入C，过滤器应该返回
。如果用户输入C，那么过滤器应该返回
 我的类别
 ---> Category.Name，ABC
 ---> Category.Name，CDE
  
到目前为止我的尝试一直是
 
 
  var v = vm.CategoryList 
 .Where（p => p.CategoryItems.Any（q => q.Name.Contains（SearchText ）））; 
  
这将过滤所有类别名称，包含与过滤器匹配的类别项目，仍然得到整个儿童类别清单，未经过滤。我缺少什么？
解决方案
您需要调用选择并返回一个过滤的子列表，如下所示：
 
 
  var v = vm.CategoryList 
 .Select（p => new {p.CategoryName，CategoryItems = p.CategoryItems.Where（q => q.Name.Contains（SearchText）））
 .Where（p => p.CategoryItems.Any（）））; 
  
 
I'm having a 'duh' moment where this seems like it should be straight forward, but I can't seem to get it right.  I have a simple collection:
Category Name
   ---> List<Category>  (Children of this category)
I want the user to be able to filter based on Category.Name while maintaining the hierarchy.  So for example.
My Category
  ---> Category.Name, "ABC"
  ---> Category.Name, "123"
  ---> Category.Name, "CDE"
If the user types C, the filter should return
My Category
  ---> Category.Name, "ABC"
  ---> Category.Name, "CDE"
My attempt thus far has been
var v = vm.CategoryList
        .Where(p => p.CategoryItems.Any(q => q.Name.Contains(SearchText)));
This will filter and give me back all Category Names that contain category items which match the filter, but I still get the entire child category list, unfiltered.  What am I missing?
解决方案
You need to call Select and return a filtered child list, like this:
var v = vm.CategoryList
          .Select(p => new { p.CategoryName, CategoryItems = p.CategoryItems.Where(q => q.Name.Contains(SearchText)))
          .Where(p => p.CategoryItems.Any()));


                        
这篇关于Linq返回筛选的孩子的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！