As you probably know each dialect may SupportsVariableLimit.
The VariableLimit supports mean that the SQL query string don't change
changing limits (pagination).
session.CreateQuery("from Person").SetMaxResult(25).SetFirstResult(50)
produce the same SQL of
session.CreateQuery("from Person").SetMaxResult(50).SetFirstResult(100)
What will change in this case will be only the parameter list.
NH are caching HQL queries translated in SQL (this is especially useful with
the new AST query-translator).
With the new implementation of MsSQL2005 pagination, the MsSQL2005Dialect
should support VariableLimits ?
--
Fabio Maulo
