Criteria.SetFetchMode and Parent.Parent doesn't work

jimjxr · **Joined:** Sun Sep 18, 2005 4:11 am **Posts:** 11

Hi,

I'm trying to use SetFetchMode to construct a query with two joins, which will bring out parent.parent in a self-referencing entity:

Code:

class Organization
{
    private Organization _parent;
    ...
}

parent property is mapped with many-to-one with cascade="none", and class has lazy=true.

I tried the following code, but it didn't work:

Code:

            ICriteria c = session.CreateCriteria(typeof(Organization))
               .Add(new EqExpression("Id", 4))
               .SetFetchMode("Parent", FetchMode.Join)
               .SetFetchMode("Parent.Parent", FetchMode.Join);

The above code can only bring out one join, it seems Parent.Parent does not work.

Any ideas?

Thanks

KPixel · **Posted:** Wed Dec 07, 2005 11:37 am

Try:

Code:

            ICriteria c = session.CreateCriteria(typeof(Organization))
               .Add(new EqExpression("Id", 4))
               .SetFetchMode("Parent", FetchMode.Join)
               .CreateCriteria(typeof(Parent))
                   .SetFetchMode("Parent", FetchMode.Join); 

jimjxr · **Joined:** Sun Sep 18, 2005 4:11 am **Posts:** 11

Thanks for the tip, you meant

Code:

            ICriteria c = session.CreateCriteria(typeof(Organization)) 
               .Add(new EqExpression("Id", 4)) 
               .SetFetchMode("Parent", FetchMode.Join) 
               .CreateCriteria("Parent") 
                   .SetFetchMode("Parent", FetchMode.Join);

right?

I tried this, but it still doesn't work...