Exemplo n.º 1
0
        public void ItShouldBePossibleToOrderDescendingByAColumn()
        {
            var expr = Select.Star <Person>()
                       .From <Person>()
                       .OrderBy <Person>(p => p.Age, Direction.Descending);
            var result   = expr.ToSqlExpression();
            var expected = TokenGeneration_SimpleOrderByTests_Results.GetOrderByDirectionExpression(Direction.Descending);

            Assert.That(result, Is.EqualTo(expected));
        }
Exemplo n.º 2
0
        public void ItShouldBePossibleToSpecifyNullsLastOrdering()
        {
            var expr = Select.Star <Person>()
                       .From <Person>()
                       .OrderBy <Person>(p => p.Age, Direction.Ascending, NullsOrdering.NullsLast);
            var result   = expr.ToSqlExpression();
            var expected =
                TokenGeneration_SimpleOrderByTests_Results.GetOrderByNullsOrderingExpression(NullsOrdering.NullsLast);

            Assert.That(result, Is.EqualTo(expected));
        }