LINQ to SQL查询，其中字符串以普通列表中的元素开头 [英] LINQ to SQL query where a string StartsWith an element from a generic list

问题描述

由于搜索要求已发生变化，我希望更新我的一个查询.最初，用户要输入一个SKU和一个mfg.搜索产品目录的日期范围.这就是我所使用的.

I'm looking to update one of my queries as the requirements for the search has changed. Originally, the user was to enter a single SKU and a mfg. date range to search the product catalog. So this is what I used.

DateTime startDate = ...;
DateTime endDate = ...;
string prodSKU = TextSKU.Text.Trim();

var results = from c in db.Products
                where c.is_disabled == false 
                && c.dom >= startDate 
                && c.dom <= endDate 
                && c.sku.StartsWith(prodSKU)
                select c;

现在，要求说用户可以在文本框中输入逗号分隔的SKU列表进行搜索.我感到难过的是如何在制造商中找到所有产品.以skuList中的任何SKU开头的日期范围(不使用fornext循环).

Now the requirement says that the user can enter a comma delimted list of SKUs into the textbox to search. What I'm stumped about is how to find all the products in the mfg. date range that begin with any of the SKUs in skuList (w/o using a fornext loop).

string prodSKU = TextSKU.Text.Trim();
List<string> skuList = prodSKU.Split(new char[] { ', ' }).ToList();

var results = from c in db.Products
                where c.is_disabled == false 
                && c.dom >= startDate 
                && c.dom <= endDate 
                // && c.sku.StartsWith(prodSKU)
                select c;

任何想法将不胜感激！

推荐答案

类似

string prodSKU = TextSKU.Text.Trim(); 
List<string> skuList = prodSKU.Split(new char[] { ', ' }).ToList();  

var results = from c in db.Products                 
   where c.is_disabled ==false                  
   && c.dom >= startDate                  
   && c.dom <= endDate                  
   &&  skuList.Any(sl=>c.sku.StartsWith(sl))                 
      select c; 

这篇关于LINQ to SQL查询，其中字符串以普通列表中的元素开头的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！