have a look to MSSQL dialects On Fri, Jul 23, 2010 at 8:46 AM, Diego Mijelshon <[email protected]>wrote:
> The idea crossed my mind... but at that point, the input is a SqlString, so > I'd have to know the actual Id column name (i.e. I can't use the > pseudo-property). > One possibility is finding the first member after the SELECT clause, which > should be the Id in non-projection queries. It might be a good compromise. > Thoughts? > > Diego > > > > On Fri, Jul 23, 2010 at 03:19, Ayende Rahien <[email protected]> wrote: > >> You can check it if has OrderBy and add Order By id? >> >> >> On Fri, Jul 23, 2010 at 12:22 AM, Diego Mijelshon <[email protected] >> > wrote: >> >>> Hi all, >>> >>> I've just created http://216.121.112.228/browse/NH-2252, to support the >>> new paging syntax (if only the full SqlServer supported it...) >>> >>> It's kinda trivial, but I have one concern... >>> >>> This syntax is only valid when there is an ORDER BY clause (which makes >>> sense). >>> SQLCE has a decent error message for it: "OFFSET clause is invalid unless >>> ORDER BY clause is specified." >>> >>> Should we leave that as-is? >>> >>> Diego >>> >> >> > -- Fabio Maulo
