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);
        }