Re: Pagination on MSSQL2005

Probably....
But in some cases if you try to do the same query and paginate it using the
MsSql2000Dialect it work without problems.
I know the have the AST parse can solve many problems and give us many other
possibility but we don't have it. Please help me to take a decision for
pagination using MsSql2005Dialect.

Please, take a look to JIRA and verify if all problems not appear using
MsSql2000Dialect... if so we can release MsSql2005Dialect in NH2.0.0GA but
using the MsSql2000Dialect pagination. The actual version of
MsSql2005Dialect can still the same but only in trunk.
Thanks.
Fabio.

2008/6/12 Ayende Rahien <[email protected]>:

> The problem is the same with the translator.
> By the time we get to the dialect, we are handing it a string, and it now
> need to start parsing that. Which isn't very nice.
> The only solution that I see is AST, but I don't think we can make it work
> for 2.0
>
> The problem is that there _isn't_ a nice way to do pagination in SQL 2005.
>
>
> On Thu, Jun 12, 2008 at 6:11 PM, Fabio Maulo <[email protected]> wrote:
>
>> Hi.
>>
>> Oren we must do something with the issues generated on pagination using
>> MsSql2005Dialect.
>> We have some issues about it and it is another "delicate" piece of code in
>> NH (like classic/QueryTranslator).
>>
>> I would like to have a "stable" decision before NH2.0.0Beta1 release (this
>> WE I'm going to release 2.0.0Alpha2)
>>
>> --
>> Fabio Maulo
>> -------------------------------------------------------------------------
>> Check out the new SourceForge.net Marketplace.
>> It's the best place to buy or sell services for
>> just about anything Open Source.
>> http://sourceforge.net/services/buy/index.php
>> _______________________________________________
>> Nhibernate-development mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/nhibernate-development
>>
>>
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> Nhibernate-development mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/nhibernate-development
>
>


-- 
Fabio Maulo

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php

_______________________________________________
Nhibernate-development mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/nhibernate-development