I already created MsSqlCe40Dialect with exactly that change :-) It's included in NHibernate 3.0 Alpha2.
Source: https://nhibernate.svn.sourceforge.net/svnroot/nhibernate/trunk/nhibernate/src/NHibernate/Dialect/MsSqlCe40Dialect.cs Diego On Tue, Aug 31, 2010 at 13:20, Richard Wilde <[email protected]> wrote: > 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]> > <nhusers%[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]<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]<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.
