Entity Framework query a comma separated field
<p>I have a table called Article:</p>

<pre><code>-Id
-Title
-Content
-Tags (This is a comma seperated list of tags e.g. 'Sports,Italy,Ferrari')
</code></pre>

<p>Using entity framework i want to be able to find all articles that have certain tags.</p>

<pre><code>List&lt;Article&gt; GetArticles(List&lt;String&gt; tags)
{
  //do an entity framework query here to find all articles which have the tags specified
} 
</code></pre>

<p>The returned entries should contain all the tags specified. 
e.g. If the input to the function was 'car','blue', then all entries with these at least these 2 tags should be returned.</p>

<p>I can't begin to imagine how i might implement this.  I know how to achieve this using a stored procedure which is my plan b.</p>