asp.net-mvc - linq比较列表到 csv 字符串

Question

我们如何在查询中将列表与 csv 字符串进行比较以获得结果？

 var q = _context.vBClaimDatas.AsQueryable();
 If (SingleProduct.Any())
  {
       List<string> str = SingleProduct.Select(i => i.ToString()).ToList();
       q = q.Where(p => str.Contains(p.ProductIds));
  }
              
   var dq = (from v in q
   select new LegalSuitReport
   {
   SingleProduct=qs.SingleProduct(),
   ClaimNo = qs.ClaimNo,         
                            
  }).ToList().Select(qs => new LegalSuitReport()
   {
   SingleProduct=qs.SingleProduct(),
    ClaimNo = qs.ClaimNo,                   
                        
   }).ToList();

例子

      var str = new List<string> {  "1","2" }                
      p.products is "1,2,4,5,6"  valid
      p.products is "6"
      p.products is "6"
      p.products is "1,7"  valid
      p.products is "4"
      p.products is "2"    valid

标签： asp.net-mvclinq