I think we should, yes.
Are there any disadvantages?
On Tue, Apr 7, 2009 at 6:19 PM, Fabio Maulo <[email protected]> wrote:
> 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
>
