title: linq search multiple columns
body: <p>I want to search for a string in multiple columns using ling-to-sql and I'm wondering how to write the <code>where</code> clause. This is what I have: I'm passing a list of IDs to search as well as a search term:</p>
  
  <pre><code>public List&lt;long&gt; Seach(string TheSearchTerm, List&lt;long&gt; TheIDs)
  {
  
  using (SomeDataContext TheDC = new SomeDataContext())
  {
      var TheOutput = (from t in TheDC.SomeTable
  
                       where TheIDs.Contains(t.ID) &amp;&amp;
                        where "TheSearchTerm is in one of the columns"
  
                       select t.ID).ToList();
      }
  }
  </code></pre>
  
  <p>How do I write the second <code>where</code> clause the searches for all the columns? I thought of writing a where clause for each column but I'm wondering if there's a better way.</p>
  
  <p>Thanks.</p>