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)); } }
public void Descending(ExpressionResult expressionResult) => _orderBy.Add( new ExpressionResult(QueryExpression.Descending(expressionResult.QueryExpression), expressionResult.RequiredJoins));
public void Descending(QueryExpression queryExpression) => _orderBy.Add(new ExpressionResult(QueryExpression.Descending(queryExpression)));