title: LINQ to SQL query where a string StartsWith an element from a generic list
body: <p>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.</p>
  
  <pre><code>DateTime startDate = ...;
  DateTime endDate = ...;
  string prodSKU = TextSKU.Text.Trim();
  
  var results = from c in db.Products
                  where c.is_disabled == false 
                  &amp;&amp; c.dom &gt;= startDate 
                  &amp;&amp; c.dom &lt;= endDate 
                  &amp;&amp; c.sku.StartsWith(prodSKU)
                  select c;
  </code></pre>
  
  <p>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).  </p>
  
  <pre><code>string prodSKU = TextSKU.Text.Trim();
  List&lt;string&gt; skuList = prodSKU.Split(new char[] { ', ' }).ToList();
  
  var results = from c in db.Products
                  where c.is_disabled == false 
                  &amp;&amp; c.dom &gt;= startDate 
                  &amp;&amp; c.dom &lt;= endDate 
                  // &amp;&amp; c.sku.StartsWith(prodSKU)
                  select c;
  </code></pre>
  
  <p>Any ideas would be greatly appreciated!</p>