title: Linq search from comma separated string to double
body: <p>Using MVC. In my form I have a textbox where user will enter item codes in this manner
  100,101,102.</p>
  
  <p>The basically I need to query the table. </p>
  
  <pre><code>if (!String.IsNullOrEmpty(searchItemcode))
  {
  
      var itemList = searchItemcode.Split(',').Select(p =&gt; p.Trim());
      priceHistory = priceHistory.Where(s =&gt; itemList.Contains(s.ITEM_CODE));
  }
  </code></pre>
  
  <p>but in the DB, my field is double and this is not working. I was thinking may be to create a list ? then use that in my linq? </p>