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