If your question is how to do it, here you have an example:
*select o from Order o join fetch o.Lines li join fetch li.Article where
o.Id = :Id*
OR
*
s.CreateCriteria(typeof (Order))
.SetFetchMode("Lines", FetchMode.Join)
.SetFetchMode("Lines.Article", FetchMode.Join)
.Add(Restrictions.Eq("Id",
orderId)).UniqueResult<Order>();*
The 3th level is Article.
On Mon, Aug 10, 2009 at 5:21 PM, mhnyborg <[email protected]> wrote:
>
> I just want to here if NH 2.1 has some new features that makes
> selection from 3 levels possible.
>
> for example I want to load all customers with all orders and order
> lines. I can get the Customers and orders using
> Transformers.DistinctRootEntity but that's only fixes the customer
> collection I get to many orders.
>
> The problem is better explained here:
>
> http://stackoverflow.com/questions/332703/nhibernate-eager-fetching-over-multiple-levels
>
>
>
> >
>
--
Dario Quintana
http://darioquintana.com.ar
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---