title: Peta Poco where clause
body: <p>I am trying to do this in petapoco</p>
  
  <pre><code>var people 
  = db.Query&lt;Person&gt;("SELECT * FROM people").Where(p =&gt; 
   p.FirstName.Equals("George") &amp;&amp; p.LastName.Equals("Clooney")).ToList();
  </code></pre>
  
  <p>the problem is that it gets the entire set of records from the database and then performs the filtration on it. I tried Fetch instead of query, same result.</p>
  
  <p>How do I write the query so that it sends the query to get the filtered results from the database, instead of doing the filtering at the webserver?</p>