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

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

Reply via email to