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 <mhnyb...@gmail.com> 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 nhusers@googlegroups.com
To unsubscribe from this group, send email to 
nhusers+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to