could not resolve property - error

maco · **Posted:** Thu Jan 03, 2008 9:38 am

Hello,

I've got a problem using ICriteria. I get the error

Quote:

{"could not resolve property: ProgramId.TitleOriginal of: DemeterDomain.TMaterial"}

when trying to get data this way:

Code:

mCriteria.Add(Expression.Like("ProgramId.ProgramId", 1));
mCriteria.Add(Expression.Like("ProgramId.TitleOriginal", "zwo"));
tmpIList = mCriteria.List();

Using Criteria with only the first "ProgramId"-expression or using session.find works perfectly:

Code:

object b = session.Find("from TMaterial as TMaterial where TMaterial.ProgramId.TitleOriginal = 'zwo'");

My Mapping files look like this:

Code:

TMaterial.hmb.xml
<many-to-one name="ProgramId" column="PROGRAM_ID" class="TProgramDetails" />

TProgram.hbm.xml
<id name="ProgramId" column="PROGRAM_ID" type="Decimal" unsaved-value="0">
         <generator class="assigned"/>
      </id>
<property column="TITLE_ORIGINAL" type="String" name="TitleOriginal" length="250" />

Does anybody have an idea what I'm doing wrong?

Thank you for any advice...

Martin

satsranchuser · **Posted:** Thu Jan 03, 2008 10:28 am

Change mCriteria.Add(Expression.Like("ProgramId.TitleOriginal", "zwo"));
to
mCriteria.Add(Expression.Like("TMaterial.TitleOriginal", "zwo"));

maco · **Posted:** Thu Jan 03, 2008 10:59 am

I'm sorry, but this doesn't work either...

I've already tried as well to use

Code:

mCriteria.Add(Expression.Like("TMaterial.ProgramId.TitleOriginal", "zwo"));

without any result (getting the same error)...

I just don't understand why I can use the "TitleOriginal"-property in the "find", but not in the "criteria"-approach...

marcal · **Posted:** Wed Jan 09, 2008 12:35 pm

Code:

mCriteria.AddAlias("ProgramId", "p");
mCriteria.Add(Expression.Like("p.ProgramId", 1));
mCriteria.Add(Expression.Like("p.TitleOriginal", "zwo"));
tmpIList = mCriteria.List();

jta · **Posted:** Wed Jan 09, 2008 12:48 pm

I think it should be:

Code:

mCriteria.CreateAlias("ProgramId", "p");

in the first line or alternatively it can be done by specifying:

Code:

mCriteria.CreateCriteria("ProgramId");
mCriteria.Add(Expression.Like("ProgramId", 1)); 
mCriteria.Add(Expression.Like("TitleOriginal", "zwo")); 
tmpIList = mCriteria.List(); 