Will do when I get it to work! :) Having trouble overriding the dialect at the moment
Looks like CE 4.0 will support paging as well so hopefully this dialect will make its way to the code base soon. http://beyondrelational.com/blogs/jacob/archive/2010/07/13/support-for-pagin g-queries-in-sql-server-ce-4-0.aspx -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MattO Sent: 31 August 2010 17:06 To: nhusers Subject: [nhusers] Re: MsSqlCeDialect and TOP keyword 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. -- 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.
