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