Hibernate version:
I'm using NHibernate version 1.0.2

Code between sessionFactory.openSession() and session.close():
NH.ICriteria criteria = GetSession().CreateCriteria(typeof(CheckPresentation));
then I try to perform this query:
criteria.Add(NH.Expression.Expression.Eq("Batch.Submitter.Branch.BranchCode", BranchCode));
Then I get the exception bellow.
The question is, can I perform such a query with NHibernate, or I need
to do other operations, before I perform this query ?
Full stack trace of any exception that occurs:
NHibernate.QueryException: could not resolve property:Batch.Submitter.Branch.BranchCode of :Datacomp.PaymentMeans.DataAccess.Model.CheckPresentation
at NHibernate.Persister.AbstractPropertyMapping.ToColumns(String alias, String propertyName)
at NHibernate.Expression.AbstractCriterion.GetColumns(ISessionFactoryImplementor factory, Type persistentClass, String property, String alias, IDictionary aliasClasses)
at NHibernate.Expression.SimpleExpression.ToSqlString(ISessionFactoryImplementor factory, Type persistentClass, String alias, IDictionary aliasClasses)
at NHibernate.Loader.CriteriaLoader..ctor(IOuterJoinLoadable persister, ISessionFactoryImplementor factory, CriteriaImpl criteria)
at NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria)
at NHibernate.Impl.CriteriaImpl.List()
at Datacomp.PaymentMeans.DataAccess.NHibernate.CheckPresentationNHibernateDAO.FindByCriteria(String DateBegin, String DateEnd, String BranchCode) in C:\work\MeiosPagamento\Iteration2\Telecompensacao\src\PaymentMeans\Datacomp.PaymentMeans.DataAccess\NHibernate\CheckPresentationNHibernateDAO.cs:line 271
at Datacomp.PaymentMeans.AdministrationApplication.Business.CheckPresentationBLL.GetChecksByDateBranch(String dateBegin, String dateEnd, String branchCode) in C:\work\MeiosPagamento\Iteration2\Telecompensacao\src\PaymentMeans\AdministrationApplication\Datacomp.PaymentMeans.AdministrationApplication\Business\CheckPresentationBLL.cs:line 298

Name and version of the database you are using:
I'm using sql server 2005

Thanks in advance for your help.

Luis

The thing is that Criteria API supports dot notation only when querying components. So if either of Submitter or Branch parts is an association, you'll either have to rewrite your query in HQL or use nested criteria.

Hi,
thank you for your answer.
Submitter is a component, however Branch is part of an Association.
Do you have a link to a good example of Nested Criteria ?
The one that we have on the NHibernate documentation is very simple and the explanation isn't very detailed.

Thanks in advance

Luis

Hi again.

I solved my problem using something like this:

criteria.CreateCriteria("Batch", "batch").Add(NH.Expression.Expression.Eq("Submitter.Branch.Id", Convert.ToInt32(BranchCode)));

I tried a couple of times, and when I finally understood it, it worked as expected. Hope this can helps someone out there.

Regards

Luis