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].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
