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