I have 2 objects a parent and a child , I want to create a select with
a where clause from child objects but I don't know how.

nhibernateSession.CreateCriteria(GetType(Parent)) _
                .SetFetchMode("Child", FetchMode.Eager) _
            .Add(Expression.Sql("ChildProperty like '%)) _
            .SetResultTransformer(New
DistinctRootEntityResultTransformer()) _
            .List(Of Parent)()

But is not working
To work with properties from parent I have {alias}.property but for
the child I don't know.

I looked on Internet but I can't find a solution for this.

Any sugestions ?

Thanks,
Mihai
--~--~---------~--~----~------------~-------~--~----~
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