public void ExecuteReaderWithPagingByPersister(int pageIndex, int pageSize)
{
var persister = new TrimReaderPersister <OrderDetail>();
using (var cmd = NorthwindRepository.GetCommand(GetOrderDetailsSql)) {
var orderDetails = NorthwindRepository.ExecuteInstance <OrderDetail>(persister, cmd, pageIndex, pageSize);
Console.WriteLine(orderDetails);
}
}
public void ExecuteReaderWithPagingByPersister(int pageIndex, int pageSize)
{
var persister = new TrimReaderPersister <OrderDetail>();
using (var cmd = Repository.GetCommand(SQL_ORDER_DETAIL_SELECT)) {
var orderDetails = Repository.ExecuteInstance <OrderDetail>(persister, cmd, pageIndex, pageSize);
Console.WriteLine(orderDetails);
}
}
public void ExecuteReaderMapTask_NameMap_Test() {
var persister = new TrimReaderPersister<Employee>(ActivatorTool.CreateInstance<Employee>);
var emps =
NWRepository.ExecuteInstanceAsync<Employee>(persister, SQL_EMPLOYEE_SELECT)
.Result;
emps.All(emp => emp.EmployeeID > 0).Should().Be.True();
emps.All(emp => emp.LastName.IsNotWhiteSpace()).Should().Be.True();
emps.All(emp => emp.FirstName.IsNotWhiteSpace()).Should().Be.True();
emps.All(emp => emp.BirthDate.HasValue && emp.BirthDate.Value < CurrentTime).Should().Be.True();
emps.All(emp => emp.Title.IsNotWhiteSpace()).Should().Be.True();
}
public void ExecuteReaderMapTask_NameMap_Test()
{
var persister = new TrimReaderPersister <Employee>(ActivatorTool.CreateInstance <Employee>);
var emps =
NWRepository.ExecuteInstanceAsync <Employee>(persister, SQL_EMPLOYEE_SELECT)
.Result;
emps.All(emp => emp.EmployeeID > 0).Should().Be.True();
emps.All(emp => emp.LastName.IsNotWhiteSpace()).Should().Be.True();
emps.All(emp => emp.FirstName.IsNotWhiteSpace()).Should().Be.True();
emps.All(emp => emp.BirthDate.HasValue && emp.BirthDate.Value < CurrentTime).Should().Be.True();
emps.All(emp => emp.Title.IsNotWhiteSpace()).Should().Be.True();
}
public void ExecuteReaderWithPagingByPersister(int pageIndex, int pageSize) {
var persister = new TrimReaderPersister<OrderDetail>();
using(var cmd = PostgreSqlRepository.GetCommand(SQL_ORDER_DETAIL_SELECT)) {
var orderDetails = PostgreSqlRepository.ExecuteInstance<OrderDetail>(persister, cmd, pageIndex, pageSize);
Console.WriteLine(orderDetails);
}
}
public void ExecuteReaderWithPagingByPersister(int pageIndex, int pageSize) {
var persister = new TrimReaderPersister<OrderDetail>();
using(var cmd = NorthwindRepository.GetCommand(GetOrderDetailsSql)) {
var orderDetails = NorthwindRepository.ExecuteInstance<OrderDetail>(persister, cmd, pageIndex, pageSize);
Console.WriteLine(orderDetails);
}
}
