How to use nhSession.CreateCriteria()?

AbdelElach · **Joined:** Fri Sep 03, 2010 5:01 am **Posts:** 3

Hi,
I have this query, it works good (this is a n:m relation!):

Code:

IQuery query = nhSession.CreateQuery("from Product prod inner join fetch prod.ProdPerCategory aProd where CategoryId = :catID ")
                             .SetParameter("catID", cat.Id);
proResult = query.List<Models.Product>();

My Question is: how to change this query to this form:

Quote:

IList test = nhSession.CreateCriteria(typeof (Product), "pr")
.CreateCriteria("ProdPerCategory", "ppc", NHibernate.SqlCommand.JoinType.InnerJoin)
.Add(Expression.Eq("CategoryId", cat.Id))
.List(); <-- dont works !!!

Thanks

wolli · **Posted:** Mon Sep 13, 2010 9:37 am

Try this:

IList test = nhSession.CreateCriteria(typeof (Product), "pr")
.CreateCriteria("pr.ProdPerCategory", "ppc", NHibernate.SqlCommand.JoinType.InnerJoin)
.Add(Expression.Eq("ppc.CategoryId", cat.Id))
.List();