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
>>
>
>
