And with a syntax like this :

            IList results = Session.CreateMultiQuery()
                .Add(Session.CreateQuery("from Order o ORDER BY o.DateAdded
DESC"))
                .Add(Session.CreateQuery("from Order o ORDER BY o.DateUpdate
ASC"))
                .List();

?

Thanks,



2009/4/27 Jason Meckley <[email protected]>

> var list = session.CreateMultiQuery
> .Add("select top 5 o from table_one o order by o.[field to sort on]
> desc")
> .Add("select top 5 o from table_two o order by o.[field to sort on]
> desc")
> .Add("select top 5 o from table_three o order by o.[field to sort on]
> desc")
> .List();

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