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