Criteria query

Smoke · **Joined:** Tue Oct 23, 2007 6:41 am **Posts:** 6

Hi forum,

I have those objects:

Parent (some properties).
Child (properties: Parent (reference to Parent, many-to-one), Value.

How can I specify criteria query for:
"select p from Parent p, Child c where c.Parent = p and c.Value = 'something'?

I would like to do it through criteria query but I don't have any clue how to define it, because I have only relation from child to parent.

Thanks for your help

Smoke

wolli · **Posted:** Wed Jun 04, 2008 3:22 am

Try something like

Code:

ICriteria crit = session.CreateCriteria(typeof(Child))
   .Add(Expression.Eq("Parent", p)
   .Add(Expression.Eq("Value", v)
   .SetProjection(Projection.Property("Parent"));