title: HQL vs Linq to objects
body: <p>I need to get the products in the system that match certain criteria.</p>
  
  <p>How should i decide if I should write an HQL and get all products that match the criteria from DB or write a Linq query directly to the main List that contain all products in the system.</p>
  
  <p>Which should be better performance vise</p>