public void Test_Between()
{
DetachedCriteria expected =
DetachedCriteria.For <Person>()
.Add(Restrictions.Between("Age", 5, 10));
DetachedCriteria actual =
DetachedCriteria.For <Person>()
.Add(SqlExpression.Between <Person>(p => p.Age, 5, 10));
AssertCriteriaAreEqual(expected, actual);
}
public void Test_BetweenUsingAlias()
{
DetachedCriteria expected =
DetachedCriteria.For <Person>("personAlias")
.Add(Restrictions.Between("personAlias.Age", 5, 10));
Person personAlias = null;
DetachedCriteria actual =
DetachedCriteria <Person> .Create(() => personAlias)
.Add(SqlExpression.Between(() => personAlias.Age, 5, 10));
AssertCriteriaAreEqual(expected, actual);
}