title: LINQ to Entities using the SQL LIKE operator
body: <p>I have this:</p>
  
  <pre><code>query = query.Where(s =&gt; s.ShowTypeDescription == showTypeDescription);
  </code></pre>
  
  <p>several times for different variables in order to build dynamic SQL.</p>
  
  <p>How would I go about transforming the above to say:</p>
  
  <pre><code>query = query.Where(s =&gt; s.ShowTypeDescription **LIKE** showTypeDescription);
  </code></pre>
  
  <p>?</p>