title: C# search query with linq
body: <p>I am trying to make a suitable linq query to accomodate my search functionality.</p>
  
  <p>I have a table with the following columns: 'firstname' | 'lastname' | 'description'.
  with the following data: 'Peter' | 'Mulder' | 'This is a little description.'</p>
  
  <p>My 'search' keyword could be something like: "peter" or "a little description".</p>
  
  <p>Now if I use the following linq expression in lambda:</p>
  
  <pre><code>mycontext.persons
      .Where(t =&gt; 
          search.Contains(t.Firstname) || 
          search.Contains(t.Lastname) || 
          search.Contains(t.Description).Select(p =&gt; p)
      .ToList();
  </code></pre>
  
  <p>Now I get my result, when I use 'peter', but if I use 'pete' or 'a little description' I get no results.
  How can I make my linq expression, so it can search through the column data for matches?</p>