title: LINQ to Entities: Why can't I use Split method as condition?
body: <p>I have the following LINQ query:</p>
  
  <pre><code>var aKeyword = "ACT";
  var results = from a in db.Activities
                where a.Keywords.Split(',').Contains(aKeyword) == true
                select a;
  </code></pre>
  
  <p>Keywords is a comma delimited field.</p>
  
  <p>Everytime I run this query I get the following error:</p>
  
  <p><strong>"LINQ to Entities does not recognize the method 'Boolean Contains[String](System.Collections.Generic.IEnumerable`1[System.String], System.String)' method, and this method cannot be translated into a store expression."</strong></p>
  
  <p>What is the alternative for what I am trying to do?</p>