public void TestOr()
{
DetachedCriteria expected =
DetachedCriteria.For <Person>()
.Add(Restrictions.Or(
Restrictions.Eq("Name", "test"),
Restrictions.Gt("Age", 5)));
DetachedCriteria actual =
DetachedCriteria.For <Person>()
.Add(Restrictions.Or(
SqlExpression.CriterionFor <Person>(p => p.Name == "test"),
SqlExpression.CriterionFor <Person>(p => p.Age > 5)));
AssertCriteriaAreEqual(expected, actual);
}
public void TestAndUsingAlias()
{
DetachedCriteria expected =
DetachedCriteria.For <Person>()
.CreateAlias("Father", "fatherAlias")
.Add(Restrictions.And(
Restrictions.Eq("Name", "test"),
Restrictions.Gt("fatherAlias.Age", 5)));
Person fatherAlias = null;
DetachedCriteria actual =
DetachedCriteria.For <Person>()
.CreateAlias <Person>(p => p.Father, () => fatherAlias)
.Add(Restrictions.And(
SqlExpression.CriterionFor <Person>(p => p.Name == "test"),
SqlExpression.CriterionFor(() => fatherAlias.Age > 5)));
AssertCriteriaAreEqual(expected, actual);
}
