title: LINQ multiple where clause
body: <p>I have a course table which I need to search based on keywords typed in the search box. 
  Here is a sample query:</p>
  
  <pre><code>SELECT * FROM Courses WHERE 
  Title LIKE '%word%' OR Title LIKE '%excel%' OR 
  Contents LIKE '%word%' OR Contents LIKE '%excel%'
  </code></pre>
  
  <p>How can I convert this in LINQ where LINQ would dynamically generate WHERE statements based on each keywords. </p>
  
  <p>I tried to user PredicateBuilder it works fine as long as the field is VARCHAR. For the "TEXT" fields the quotes are not generated thus causing compiler to give an error message. Here is the SQL generated by PredicateBuilder</p>
  
  <pre><code>SELECT [t0].[CoursesID], [t0].[Title], [t0].[Contents], [t0].[Active], 
  FROM [dbo].[Courses] AS [t0]
  WHERE ([t0].[Title] LIKE '%word%') OR ([t0].[Contents] LIKE %word%) OR 
  ([t0].Title] LIKE '%excel%') OR ([t0].[Contents] LIKE %excel%)
  </code></pre>
  
  <p>Notice there is no single Quote for the "Contents" field which is a Text field in the database.</p>
  
  <p>Is there any easy way to build WHERE statement and attach it with query? Does anyone know how I can do this without PredicateBuilder?</p>
  
  <p>Thanks in advance.</p>