title: using split in linq query
body: <p>in one of my database fields i have data as follows:</p>
  
  <pre><code>value1, value2, value3
  </code></pre>
  
  <p>my search parameter could be value1 or value2 or value3</p>
  
  <p>what i want to do is use a linq query to get a list of entities where for e.g. value2 is in "value1, value2, value3"</p>
  
  <p>also, values are seperated by space after the commma.</p>
  
  <p>i tried to use the following linq query but got an error that stated Array operation not permitted.</p>
  
  <pre><code>List&lt;Players&gt; c = (from p in db.Players
                        where (p.Users == "Everyone" || p.Users.Split()[','].Trim().Contains(username))
                        orderby p.Category ascending
                        select p).ToList();
  </code></pre>
  
  <p>any ideas how this can be accomplished?</p>