Hi,

I was just reading through the documentation and found different ways to retrieve data from the database. If I want to get data
- from different tables
- defining a set of search criteria
- which way is the best or let's say the most performant one to go:
HQL, Criteria Query, Stored Procedures, retrieve everything and doing the work in the code (FOREACHs), ...

Is there a best practice?

Could anybody help me to go the right way???

Thanks for your help

antoschka

I favor ICriteria because it is more type safe than HQL and it makes managing variable search criteria easier because you tell NHibernate what you want to do and it handles the implementation details. To me SPs are an unnecessary and less testable layer. And doing everything in code seems to miss the point of relational databases.

Thanks - that was the information I was looking for.

One Last Question:
Do I have the same possibilities to tweak performance through caching as I would have with other Query Technologies such as HQL?

Thanks in advance

antoschka

Yes, both IQuery (HQL) and ICriteria leverage both levels of NHibernate's cache.