public async Task <IEnumerable <Person> > Get()
{
var orderBy = OrderField.Descending <Person>(p => p.Id).AsEnumerable();
var topRows = 10;
return((await personRepository.QueryAsync(what: null, top: topRows, orderBy: orderBy)).AsList());
}
public void TestOrderFieldForDescending()
{
// Act
var parsed = OrderField.Descending <OrderFieldTestClass>(p => p.Id);
// Assert
Assert.AreEqual(Order.Descending, parsed.Order);
}
public void TestOrderFielDecendingFromMappedProperty()
{
// Act
var parsed = OrderField.Descending <OrderFieldTestMappedClass>(p => p.PropertyString);
// Assert
Assert.AreEqual("PropertyText", parsed.Name);
Assert.AreEqual(Order.Descending, parsed.Order);
}
public void TestMySqlConnectionBatchQueryThirdBatchDescending()
{
// Setup
var tables = Database.CreateCompleteTables(10);
using (var connection = new MySqlConnection(Database.ConnectionString))
{
// Act
var result = connection.BatchQuery <CompleteTable>(2,
3,
OrderField.Descending <CompleteTable>(c => c.Id).AsEnumerable(),
(object)null);
// Assert
Helper.AssertPropertiesEquality(tables.ElementAt(3), result.ElementAt(0));
Helper.AssertPropertiesEquality(tables.ElementAt(1), result.ElementAt(2));
}
}
public void TestSqLiteConnectionBatchQueryFirstBatchDescending()
{
using (var connection = new SQLiteConnection(Database.ConnectionStringSDS))
{
// Setup
var tables = Database.CreateSdsCompleteTables(10, connection);
// Act
var result = connection.BatchQuery <SdsCompleteTable>(0,
3,
OrderField.Descending <SdsCompleteTable>(c => c.Id).AsEnumerable(),
(object)null);
// Assert
Helper.AssertPropertiesEquality(tables.ElementAt(9), result.ElementAt(0));
Helper.AssertPropertiesEquality(tables.ElementAt(7), result.ElementAt(2));
}
}
public void TestSqLiteConnectionBatchQueryAsyncThirdBatchDescending()
{
using (var connection = new SqliteConnection(Database.ConnectionStringMDS))
{
// Setup
var tables = Database.CreateMdsCompleteTables(10, connection);
// Act
var result = connection.BatchQueryAsync <MdsCompleteTable>(2,
3,
OrderField.Descending <MdsCompleteTable>(c => c.Id).AsEnumerable(),
(object)null).Result;
// Assert
Helper.AssertPropertiesEquality(tables.ElementAt(3), result.ElementAt(0));
Helper.AssertPropertiesEquality(tables.ElementAt(1), result.ElementAt(2));
}
}
public void TestSqlServerConnectionBatchQueryAsyncFirstBatchDescending()
{
// Setup
var tables = Database.CreateCompleteTables(10);
using (var connection = new SqlConnection(Database.ConnectionString))
{
// Act
var result = connection.BatchQueryAsync <CompleteTable>(0,
3,
OrderField.Descending <CompleteTable>(c => c.Id).AsEnumerable(),
(object)null).Result;
// Assert
Helper.AssertPropertiesEquality(tables.ElementAt(9), result.ElementAt(0));
Helper.AssertPropertiesEquality(tables.ElementAt(7), result.ElementAt(2));
}
}
public void TestMySqlConnectionBatchQueryViaTableNameAsyncThirdBatchDescending()
{
// Setup
var tables = Database.CreateCompleteTables(10);
using (var connection = new MySqlConnection(Database.ConnectionString))
{
// Act
var result = connection.BatchQueryAsync(ClassMappedNameCache.Get <CompleteTable>(),
2,
3,
OrderField.Descending <CompleteTable>(c => c.Id).AsEnumerable(),
(object)null).Result;
// Assert
Helper.AssertMembersEquality(tables.ElementAt(3), result.ElementAt(0));
Helper.AssertMembersEquality(tables.ElementAt(1), result.ElementAt(2));
}
}
public void TestSqLiteConnectionBatchQueryViaTableNameAsyncFirstBatchDescending()
{
using (var connection = new SQLiteConnection(Database.ConnectionStringSDS))
{
// Setup
var tables = Database.CreateSdsCompleteTables(10, connection);
// Act
var result = connection.BatchQueryAsync(ClassMappedNameCache.Get <SdsCompleteTable>(),
0,
3,
OrderField.Descending <SdsCompleteTable>(c => c.Id).AsEnumerable(),
(object)null).Result;
// Assert
Helper.AssertMembersEquality(tables.ElementAt(9), result.ElementAt(0));
Helper.AssertMembersEquality(tables.ElementAt(7), result.ElementAt(2));
}
}
public void TestPostgreSqlConnectionBatchQueryViaTableNameFirstBatchDescending()
{
// Setup
var tables = Database.CreateCompleteTables(10);
using (var connection = new NpgsqlConnection(Database.ConnectionString))
{
// Act
var result = connection.BatchQuery(ClassMappedNameCache.Get <CompleteTable>(),
0,
3,
OrderField.Descending <CompleteTable>(c => c.Id).AsEnumerable(),
(object)null);
// Assert
Helper.AssertMembersEquality(tables.ElementAt(9), result.ElementAt(0));
Helper.AssertMembersEquality(tables.ElementAt(7), result.ElementAt(2));
}
}