In MsSqlCeDialect, SupportsLimit is false. You can override it.
Diego
On Tue, Aug 31, 2010 at 07:14, Richard Wilde <[email protected]> wrote:
> Hi all,
>
>
>
> Is the TOP keyword supported for the MsSqlCeDialect? Since 3.5 SQL CE
> supports TOP using the following format (notice the braces)
>
>
>
> SELECT TOP(10) * FROM Purchase ORDER BY PurchaseDate
>
>
>
> However I have tried HQL and Criteria using SetMaxResults to limit my
> results without success and according to NHProf the TOP keyword is not
> inserted into the generated SQL.
>
>
>
> However I can use the following OK:-
>
>
>
> .CreateSQLQuery("SELECT TOP(:count) * FROM Purchase ORDER BY PurchaseDate")
>
> .AddEntity(typeof (Purchase))
>
> .SetInt32("count", count);
>
>
>
> Is this a known issue and I need to use CreateSQLQuery as a work around?
>
>
>
> Thanks, Rippo
>
> --
> You received this message because you are subscribed to the Google Groups
> "nhusers" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected]<nhusers%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/nhusers?hl=en.
>
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
