If you do override it you might consider submitting a new dialect MsSqlCe35Dialect to the nHibernate code base so others can use it :-)
On Aug 31, 7:40 am, Diego Mijelshon <[email protected]> wrote: > 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.- Hide quoted text - > > - Show quoted text - -- 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.
