Exemplos de QueryExpression.Descending em C# (CSharp)

Exemplo n.º 1

Arquivo: SelectTests.cs Projeto: SilkStack/Silk.Data.SQL.ProviderTests

        public virtual async Task Select_WithOrderBy()
        {
            using (var tempTable = await Select_CreatePopulatedSelectTable())
                using (var queryResult = await DataProvider.ExecuteReaderAsync(
                           QueryExpression.Select(
                               new[] { QueryExpression.All() },
                               from: QueryExpression.Table(tempTable.TableName),
                               orderBy: new[] { QueryExpression.Descending(QueryExpression.Column("Data")) }
                               )))
                {
                    Assert.IsTrue(queryResult.HasRows);

                    Assert.IsTrue(await queryResult.ReadAsync());
                    Assert.AreEqual(3, queryResult.GetInt32(1));
                    Assert.IsTrue(await queryResult.ReadAsync());
                    Assert.AreEqual(3, queryResult.GetInt32(1));

                    Assert.IsTrue(await queryResult.ReadAsync());
                    Assert.AreEqual(2, queryResult.GetInt32(1));
                    Assert.IsTrue(await queryResult.ReadAsync());
                    Assert.AreEqual(2, queryResult.GetInt32(1));

                    Assert.IsTrue(await queryResult.ReadAsync());
                    Assert.AreEqual(1, queryResult.GetInt32(1));
                    Assert.IsTrue(await queryResult.ReadAsync());
                    Assert.AreEqual(1, queryResult.GetInt32(1));
                }
        }

Exemplo n.º 2

 public void Descending(ExpressionResult expressionResult)
 => _orderBy.Add(
     new ExpressionResult(QueryExpression.Descending(expressionResult.QueryExpression),
                          expressionResult.RequiredJoins));

Exemplo n.º 3

 public void Descending(QueryExpression queryExpression)
 => _orderBy.Add(new ExpressionResult(QueryExpression.Descending(queryExpression)));