Criteria based on many-to-one parent...

nathanbaulch · **Joined:** Wed Aug 31, 2005 9:29 pm **Posts:** 14

Using the standard "Cacades" example with Parent and Child objects, how would I create a criteria that looks up all children with parents whose name starts with the letter "A"?

In SQL:

Code:

    select *
    from cas_child c
    left join cas_parent p on c.parent_id = p.id
    where p.name like 'A%'

Something like:

Code:

    IList children = session.CreateCriteria(typeof (Child))
        .Add(Expression.Like("SingleParent.Name", "A%"))
        .List();

Obviously dot notation is not supported in the first parameter.

michal · **Posted:** Thu Sep 01, 2005 6:02 am

Not possible with criteria. Use HQL:

Code:

q=session.CreateQuery("select c from cas_child c where c.SingleParent.Name like :name")
q.setString("name","A%")
q.List()