- Very flexible
- The only way to express some complex queries
But also the negatives - no compile-time syntax checking.
The Criteria API:
- Provides compile-time syntax checking
- Intellisense when working with Visual Studio
HQL vs NHibernate Criteria API
HQL offers the benefits of literal SQL: