public void ThrowExceptionOnSqLiteConnectionBatchQueryAsyncWithHints() { using (var connection = new SQLiteConnection(Database.ConnectionStringSDS)) { // Setup var tables = Database.CreateSdsCompleteTables(10, connection); // Act connection.BatchQueryAsync <SdsCompleteTable>(0, 3, OrderField.Ascending <SdsCompleteTable>(c => c.Id).AsEnumerable(), (object)null, hints: "WhatEver").Wait(); } }
public void ThrowExceptionOnSqLiteConnectionBatchQueryAsyncViaTableNameWithHints() { using (var connection = new SQLiteConnection(Database.ConnectionString)) { // Setup var tables = Database.CreateCompleteTables(10, connection); // Act connection.BatchQueryAsync(ClassMappedNameCache.Get <CompleteTable>(), 0, 3, OrderField.Ascending <CompleteTable>(c => c.Id).AsEnumerable(), (object)null, hints: "WhatEver").Wait(); } }
public void TestSqLiteConnectionBatchQueryAsyncThirdBatchDescending() { using (var connection = new SQLiteConnection(Database.ConnectionStringSDS)) { // Setup var tables = Database.CreateSdsCompleteTables(10, connection); // Act var result = connection.BatchQueryAsync <SdsCompleteTable>(2, 3, OrderField.Descending <SdsCompleteTable>(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 TestSqLiteConnectionBatchQueryViaTableNameAsyncThirdBatchAscending() { using (var connection = new SQLiteConnection(Database.ConnectionStringSDS)) { // Setup var tables = Database.CreateSdsCompleteTables(10, connection); // Act var result = connection.BatchQueryAsync(ClassMappedNameCache.Get <SdsCompleteTable>(), 2, 3, OrderField.Ascending <SdsCompleteTable>(c => c.Id).AsEnumerable(), (object)null).Result; // Assert Helper.AssertMembersEquality(tables.ElementAt(6), result.ElementAt(0)); Helper.AssertMembersEquality(tables.ElementAt(8), result.ElementAt(2)); } }