Criteria-Search and subquerry

maco · **Posted:** Mon Mar 10, 2008 5:28 am

Hieverybody!

I've got a question about ICriteria and Subquerries.

I use

Code:

mCritSearch = session.CreateCriteria(typeof(TMaterial));
mCritProgramId = mCritSearch.CreateCriteria("ProgramId");

mCritSearch.Add(Expression.Eq("Name", inValue));
mCritProgramId.Add(Expression.Eq("Name", inValue));

which delivers me all the TMaterial Objects where the "Name" attribute of the TMaterial and the "Name" of the TProgram subclass equals my inValue. But instead of haeving an AND connection between these two, I would like to search for an OR to get all the results where at least one of the two "Name" meets my inValue.

Do you know how I could solve this? Thanks for any kind of help.

Best regards, Martin

wolli · **Posted:** Mon Mar 10, 2008 6:56 am

I think this should work:

mCritSearch = session.CreateCriteria(typeof(TMaterial), "m")
.CreateCriteria("ProgramId", "p")
.Add(
Expression.Or(
Expression.Eq("m.Name", inValue),
Expression.Eq("p.Name", inValue)
)
);