title: comma separated column in linq where clause
body: <p>i have string of value like "4,3,8"</p>
  
  <p>and i had comma separated column in table as below.</p>
  
  <pre>
  <b>
  
      ID   |  PrdID   |  cntrlIDs </b>
      1    |   1      |   4,8
      2    |   2      |   3
      3    |   3      |   3,4
      4    |   4      |   5,6
      5    |   5      |   10,14,18
  
  </pre>
  
  <p>i want only those records from above table which match in above mention string</p>
  
  <p>eg.
  1,2,3 this records will need in output because its match with the passing string of "4,3,8"</p>
  
  <p>Note : i need this in entity framework LINQ Query.</p>
  
  <pre><code>string[] arrSearchFilter = "4,3,8".Split(',');
  var query = (from prdtbl in ProductTables 
  where prdtbl.cntrlIDs.Split(',').Any(x=&gt; arrSearchFilter.Contains(x))
  </code></pre>
  
  <p>but its not working and i got below error</p>
  
  <blockquote>
    <p>LINQ to Entities does not recognize the method 'System.String[] Split(Char[])' method, and this method cannot be translated into a store expression.</p>
  </blockquote>