doh! what's phb anyway?
Tuna Toksöz http://tunatoksoz.com http://turkiyealt.net http://twitter.com/tehlike Typos included to enhance the readers attention! On Tue, Mar 3, 2009 at 10:50 PM, Robin Nadeau <[email protected]> wrote: > I want to use HQL or criteria API, but PHBs insist we stick with native > SQL. How difficult would this be to fix in the provider for sql server? > Thanks for your response. > > On Tue, Mar 3, 2009 at 3:36 PM, Fabio Maulo <[email protected]> wrote: > >> I mean... If you want a pure SQL don't use SetMaxResults >> or SetFirstResult, write the full SQL by your self. >> If you want NH doing something, write the SQL in a way NH can understand >> how work with it. >> >> 2009/3/3 Fabio Maulo <[email protected]> >> >> sure it fail.You should use H-SQL if you want that NH do something with >>> your SQL or you should use HQL or Criteria. >>> >>> SELECT {u.*} FROM USER {u} ORDER BY id desc") >>> >>> For H-SQL : >>> http://nhforge.org/doc/nh/en/index.html#manipulatingdata-nativesql >>> >>> 2009/3/3 Robin Nadeau <[email protected]> >>> >>> In NHibernate 2.0 using SQL Server 2008, if I create a query such as: >>>> Session.CreateSQLQuery("SELECT * FROM USER ORDER BY id >>>> desc").AddEntity(typeof(User).SetMaxResults(100).SetFirstResult(1).List<User>(); >>>> >>>> Then the sql statement fails. >>>> >>>> -- >>>> Robin Nadeau, B.Eng. >>>> Software Developer >>>> >>>> >>>> >>> >>> >>> -- >>> Fabio Maulo >>> >> >> >> >> -- >> Fabio Maulo >> >> >> > > > -- > Robin Nadeau, B.Eng. > Software Developer > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
