Found :
IList results = Session.CreateMultiQuery()
.Add(Session.CreateQuery("from Order o ORDER BY o.DateAdded
DESC")
.SetMaxResults(10))
.List();
2009/4/27 Kris-I
> And with a syntax like this :
>
> IList results = Session
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/
something like
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();
var one =
