title: Lambda Expressions and Stored Procedures
body: <p>I'm trying to mimic the LINQ Where extension method for my ADO.NET DAL methods.</p>
  
  <p>Bascially, my aim is to have a single method that I can call.  Such as:</p>
  
  <pre><code>Product p = Dal.GetProduct(x =&gt; x.ProductId == 32);
  Product p2 = Dal.GetProduct(x =&gt; x.ProductName.Contains("Soap"));
  </code></pre>
  
  <p>I then want to dissect those Predicates and send the filter options to parameters in an ADO.NET Stored Procedure call.</p>
  
  <p>Any comments greatly appreciated.</p>