title: ServiceStack OrmLite generic database search
body: <p>I need simple search functionality in different tables through my application, so I was thinking creating a <code>GenericFilter</code> class, passing a query and some conditions and return the results in some way.</p>
  
  <p>Is it possible with OrmLite to return such a list, or another structure? An example would be:</p>
  
  <pre><code>var result = db.Sel???("select ID, FirstName, LastName from Customers where City='Paris'");
  </code></pre>
  
  <p>The result could be anything, from a <code>DataTable</code> to an <code>array</code>. 
  Thanks!</p>