public void ExecutePagingDataTableBySelectSqlTest(int pageIndex, int pageSize, double discount)
{
const string selectSql = GetOrderDetailsSql + @" WHERE Discount > @Discount";
var parameters = new AdoParameter[] { new AdoParameter("Discount", discount) };
using (
new OperationTimer(string.Format("ExecutePagingDataTableBySqlString(pageIndex=[{0}], pageSize=[{1}])", pageIndex,
pageSize)))
using (var pagingTable = SqlRepository.ExecutePagingDataTableBySqlString(selectSql, pageIndex, pageSize, parameters)) {
Assert.AreEqual(pageIndex, pagingTable.PageIndex);
Assert.AreEqual(pageSize, pagingTable.PageSize);
Assert.IsTrue(pagingTable.TotalPageCount > 0);
Assert.IsTrue(pagingTable.TotalItemCount > 0);
Assert.IsTrue(pagingTable.Table.Rows.Count > 0);
Assert.IsTrue(pagingTable.Table.Rows.Count <= pageSize);
var table = pagingTable.Table;
Assert.IsNotNull(table);
Assert.IsFalse(table.HasErrors);
Assert.IsTrue(table.Rows.Count > 0);
}
Console.WriteLine("Waiting for Verify Connection Pooling");
}
public void ExecuteNonQueryAsyncBySqlString_WithParametersTest()
{
var region = new AdoParameter("RegionID", 1000);
using (var asyncTask = NorthwindDb.ExecuteNonQueryAsync("DELETE FROM Region where RegionID >= :RegionID", region)) {
asyncTask.Wait();
AssertTaskIsCompleted(asyncTask);
// ExecuteNonQuery를 수행하면, 삭제한 레코드가 없기 때문에 결과 값은 0 입니다.
//
asyncTask.Result.Should().Be(0);
}
}
public void ExecutePagingDataTableBySelectSqlTest(int pageIndex, int pageSize, double discount)
{
const string selectSql = SQL_ORDER_DETAIL_SELECT + @" WHERE Discount > @Discount";
var parameters = new AdoParameter[] { new AdoParameter("Discount", discount) };
using (
new OperationTimer(string.Format("ExecutePagingDataTableBySqlString(pageIndex=[{0}], pageSize=[{1}])", pageIndex,
pageSize)))
using (var pagingTable = Repository.ExecutePagingDataTableBySqlString(selectSql, pageIndex, pageSize, parameters)) {
Assert.AreEqual(pageIndex, pagingTable.PageIndex);
Assert.AreEqual(pageSize, pagingTable.PageSize);
Assert.IsTrue(pagingTable.TotalPageCount > 0);
Assert.IsTrue(pagingTable.TotalItemCount > 0);
Assert.IsTrue(pagingTable.Table.Rows.Count > 0);
Assert.IsTrue(pagingTable.Table.Rows.Count <= pageSize);
var table = pagingTable.Table;
Assert.IsNotNull(table);
Assert.IsFalse(table.HasErrors);
Assert.IsTrue(table.Rows.Count > 0);
}
}
public void ExecutePagingDataTableBySelectSqlTest(int pageIndex, int pageSize, double discount) {
const string selectSql = SQL_ORDER_DETAIL_SELECT + @" WHERE Discount > :Discount";
var parameters = new AdoParameter[] { new AdoParameter("Discount", discount) };
using(
new OperationTimer(string.Format("ExecutePagingDataTableBySqlString(pageIndex=[{0}], pageSize=[{1}])", pageIndex,
pageSize)))
using(var pagingTable = PostgreSqlRepository.ExecutePagingDataTableBySqlString(selectSql, pageIndex, pageSize, parameters)) {
Assert.AreEqual(pageIndex, pagingTable.PageIndex);
Assert.AreEqual(pageSize, pagingTable.PageSize);
Assert.IsTrue(pagingTable.TotalPageCount > 0);
Assert.IsTrue(pagingTable.TotalItemCount > 0);
Assert.IsTrue(pagingTable.Table.Rows.Count > 0);
Assert.IsTrue(pagingTable.Table.Rows.Count <= pageSize);
var table = pagingTable.Table;
Assert.IsNotNull(table);
Assert.IsFalse(table.HasErrors);
Assert.IsTrue(table.Rows.Count > 0);
}
}
public void ExecutePagingDataTableBySelectSqlTest(int pageIndex, int pageSize, double discount) {
const string selectSql = GetOrderDetailsSql + @" WHERE Discount > @Discount";
var parameters = new AdoParameter[] { new AdoParameter("Discount", discount) };
using(
new OperationTimer(string.Format("ExecutePagingDataTableBySqlString(pageIndex={0}, pageSize={1})", pageIndex, pageSize))
)
using(var pagingTable = SQLiteRepository.ExecutePagingDataTableBySqlString(selectSql, pageIndex, pageSize, parameters)) {
Assert.AreEqual(pageIndex, pagingTable.PageIndex);
Assert.AreEqual(pageSize, pagingTable.PageSize);
Assert.IsTrue(pagingTable.TotalPageCount > 0);
Assert.IsTrue(pagingTable.TotalItemCount > 0);
Assert.IsTrue(pagingTable.Table.Rows.Count > 0);
Assert.IsTrue(pagingTable.Table.Rows.Count <= pageSize);
var table = pagingTable.Table;
Assert.IsNotNull(table);
Assert.IsFalse(table.HasErrors);
Assert.IsTrue(table.Rows.Count > 0);
}
}
public void ExecuteNonQueryAsyncBySqlString_WithParametersTest() {
var region = new AdoParameter("RegionID", 1000);
using(var asyncTask = NorthwindDb.ExecuteNonQueryAsync("DELETE FROM Region where RegionID >= :RegionID", region)) {
asyncTask.Wait();
AssertTaskIsCompleted(asyncTask);
// ExecuteNonQuery를 수행하면, 삭제한 레코드가 없기 때문에 결과 값은 0 입니다.
//
asyncTask.Result.Should().Be(0);
}
}
