title: LINQ to SQL where clause verifying string contains list element
body: <p>I'm using a view returning Domains according to an id. The Domains column can be 'Geography' or can be stuffed domains 'Geography,History'. (In any way, the data returned is a VARCHAR)</p>
  
  <p>In my C# code, I have a list containing main domains:</p>
  
  <pre><code>private static List&lt;string&gt; _mainDomains = new List&lt;string&gt;()
  {
      "Geography",
      "Mathematics",
      "English"
  };
  </code></pre>
  
  <p>I want to filter my <a href="http://en.wikipedia.org/wiki/Language_Integrated_Query" rel="nofollow">LINQ</a> query in order to return only data related to one or many main Domain:</p>
  
  <pre><code>expression = i =&gt; _mainDomains.Any(s =&gt; i.Domains.Contains(s));
  var results = (from v_lq in context.my_view
                  select v_lq).Where(expression)
  </code></pre>
  
  <p>The problem is I can't use the <code>Any</code> key word, nor the <code>Exists</code> keyword, since they aren't available in SQL. I've seen many solutions using the <code>Contains</code> keyword, but it doesn't fit to my problem.</p>
  
  <p>What should I do?</p>