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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
