Hey Frans,

Was wondering if you will (or already are) using the new features of SQL 2005 (ROW_NUMBER) for paging. Maybe there's no real advantage to doing it the "new" way--I haven't seen any performance tests yet.

As a semi-related aside, I'm currently doing a project in which I can't use LLBL, and having to support paging via stored procs. It's not that bad until you realize how hard it is to support dynamic sorting within a proc.

The ease of using typed lists with paging/sorting via LLBL is worth the cost of the product all by itself.

Yes v2 will have a setting which you can use in code or in the .config file to switch compatibility mode of the sqlserver dqe. If you set it to 2005, you'll get WITH... paging, otherwise the temptable variant

Sounds good. Looking forward to that release