title: Creating a dynamic query using IQueryable
body: <p>I'm trying to iterate for over an string array and dynamically create a <code>IQueryable</code> query. Its pretty straightforward but here's where I'm stuck</p>
  
  <pre><code>var query = context.QuestionsMetaDatas.AsQueryable();
  
  var keywords=new List&lt;string&gt;(){ "Test1","Test2" };
  
  foreach(var key in keywords)
  {
     query=query.Where(a=&gt;a.Text.Contains(key));
  }
  </code></pre>
  
  <p>Now the problem is that when the query gets generated its compiles to </p>
  
  <pre><code>select * from QuestionsMetaDatas where Text Like "Test1" AND Text Like "Test2"
  </code></pre>
  
  <p>Instead of <code>AND</code> I wanted the query to generate <code>OR</code>...Now how can I achieve this?</p>