Filter on value in a subcollection

Selector2007 · **Joined:** Tue Jul 29, 2008 10:53 am **Posts:** 11

Let's say we have an Order and a Version.
Order is the main class, and every order has one or more versions:

Code:

Public class Order
{
   public Order()

   public virtual OrderCompany
   {
      get ...
      set ...
   }

   public virtual ISet Versions
   {
      get ...
      set ...
   }
}

I've mapped these classes and everything works perfectly.

Now I want to search for specific orders. If I search for orders from a company I use an expression:

LikeExpression LE = new LikeExpression("OrderCompany", "%CompanyX%");
This works very nice.

But now I would like to get only the orders that have a version 2: something like this:

EqExpression EE = new EqExpression("Versions.Number", "2");
But this doesn't work.

Anyone knows how to get what I want?

wolli · **Posted:** Tue Jul 29, 2008 11:33 am

You need a subcriteria:

Code:

ICriteria crit = session.CreateCriteria(typeof(Order),"o")
   .Add(Expression.Like("o.OrderCompany", "%CompanyX%))
   .CreateCriteria("o.Versions", "v")
       .Add(Expression.Eq("v.Version", "2"));

Selector2007 · **Joined:** Tue Jul 29, 2008 10:53 am **Posts:** 11

Thanks Wolli. That works prefectly!