And/Or of 2 Criteria/DetachedCriteria

kriwec · **Posted:** Tue May 13, 2008 2:16 am

Hi All,
How I could add(and/or) one Criteria/DetachedCriteria to another?
(
something like:
ICriteria.And(ICriteria), ICriteria.Or(ICriteria), DetachedCriteria.And(DetachedCriteria), DetachedCriteria.Or(DetachedCriteria)
)

We could easily add one ICriterion to another:
finalCriterion = Expression.And(finalCriterion, localCriterion);
finalCriterion = Expression.Or(finalCriterion, localCriterion);

How I could and/or such Criteria:
finalCriteria.Add(Expression.Ge("Datecreated", value2));
localCriteria.Add(Expression.InsensitiveLike("Name", value1));

Regards

wolli · **Posted:** Tue May 13, 2008 5:19 am

You can create a Conjunction/Disjunction as container for your expressions and add them to a final criteria:

Code:

Disjunction or = Expression.Disjunction();
or.Add( Expression... );
or.Add( Expression... );

Conjunction and = Expression.Conjunction();
and.Add( Expression... );
and.Add( Expression... );

criteria.Add(and);
criteria.Add(or);

Is that what you're looking for ?