! That is what I am doing. In the sql query I also had a orderby NEWID(), which was the main reason for using direct sql, as I did not find a way to do NEWID using NHibernate. But even after removing that line, the resulting query that NHibernate generated was the above.
Also in the method where I call the CreateSQLQuery I have: sqlQuery.SetMaxResults(5); - AB On Feb 11, 1:02 pm, Fabio Maulo <[email protected]> wrote: > 2009/2/11 Garfield <[email protected]> > > > > > This is how I am calling the CreateSQLQuery: > > ISQLQuery sqlQuery = NHibernateSession.CreateSQLQuery(sql).AddEntity > > (alias, type); > > Please say the true. That is not what you are doing... you are setting > something else.Thanks. > > 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 -~----------~----~----~----~------~----~------~--~---
