public void FluentByNameMapper_Load()
{
INameMapper nameMapper = new CapitalizeNameMapper();
using (var cmd = SQLiteRepository.GetCommand(GetCustomerOrderHistorySql)) {
var orderHistories = SQLiteRepository.ExecuteInstance <CustomerOrderHistory>(nameMapper, cmd, CustomerTestParameter);
Assert.Greater(orderHistories.Count, 0);
CollectionAssert.AllItemsAreNotNull((ICollection)orderHistories);
CollectionAssert.AllItemsAreInstancesOfType((ICollection)orderHistories, typeof(CustomerOrderHistory));
}
}
public void FluentByNameMapper_Load()
{
INameMapper nameMapper = new CapitalizeNameMapper();
using (var cmd = AdoRepository.GetCommand("CustOrderHist2")) {
var orderHistories = AdoRepository.ExecuteInstance <CustomerOrderHistory>(nameMapper, cmd, CustomerTestParameter);
orderHistories.Count.Should().Be.GreaterThan(0);
CollectionAssert.AllItemsAreNotNull((ICollection)orderHistories);
CollectionAssert.AllItemsAreInstancesOfType((ICollection)orderHistories, typeof(CustomerOrderHistory));
}
}
public void MapFromDataReader_Employee_With_DynamicProxy()
{
var capitalizeNameMapper = new CapitalizeNameMapper();
using (var reader = NorthwindAdoRepository.ExecuteReaderBySqlString(SQL_EMPLOYEE_SELECT)) {
var employees = reader.Map <Employee>(DynamicProxyTool.CreateEditablePropertyChanged <Employee>, capitalizeNameMapper);
Assert.Greater(employees.Count, 0);
employees.All(emp => emp.EmployeeID > 0).Should().Be.True();
employees.All(emp => emp.BirthDate.HasValue).Should().Be.True();
// 모든 엔티티가 Proxy 된 것입니다!!!
employees.All(emp => emp.IsDynamicProxy()).Should().Be.True();
}
}
public void MapFromDataReader_OrderDetails_DynamicProxy()
{
var capitalizeNameMapper = new CapitalizeNameMapper();
using (var reader = NorthwindAdoRepository.ExecuteReaderBySqlString(SQL_ORDER_DETAIL_SELECT)) {
var orderDetails = reader.Map <OrderDetail>(DynamicProxyTool.CreateEditablePropertyChanged <OrderDetail>, CapitalizeMapper);
Assert.Greater(orderDetails.Count, 0);
orderDetails.All(od => od.OrderID > 0).Should().Be.True();
orderDetails.All(od => od.ProductID > 0).Should().Be.True();
orderDetails.All(od => od.Quantity > 0).Should().Be.True();
orderDetails.All(od => od.Discount >= 0.0f).Should().Be.True();
// 모든 엔티티가 Proxy 된 것입니다!!!
orderDetails.All(od => od.IsDynamicProxy()).Should().Be.True();
}
}
public void FluentByNameMapper_Save()
{
INameMapper nameMapper = new CapitalizeNameMapper();
var category = new Category
{
CategoryName = "Test",
Description = "FluentUtil"
};
// delete exist category
SQLiteRepository.ExecuteNonQueryBySqlString("DELETE FROM Categories where CategoryName = @CategoryName",
new AdoParameter("CategoryName", category.CategoryName, DbType.String, 255));
// insert
var result = SQLiteRepository.ExecuteEntity("SaveOrUpdateCategory", category, nameMapper);
category.CategoryId = result.AsInt(-1); //ConvertTool.DefValue(result, -1);
Assert.AreNotEqual(-1, category.CategoryId);
// update
result = SQLiteRepository.ExecuteEntity("SaveOrUpdateCategory", category, nameMapper);
Assert.AreNotEqual(0, result.AsInt());
}
public void FluentByNameMapper_Save()
{
INameMapper nameMapper = new CapitalizeNameMapper();
var category = new Category
{
CategoryName = "Test",
Description = "FluentUtil"
};
// delete exist category
NorthwindAdoRepository.ExecuteNonQueryBySqlString("DELETE FROM Categories where CategoryName = @CategoryName",
new AdoParameter("CategoryName", category.CategoryName));
// insert
var result = NorthwindAdoRepository.ExecuteEntity("SaveOrUpdateCategory", category, nameMapper);
category.CategoryId = result.AsInt(-1);
Assert.AreNotEqual(-1, category.CategoryId);
// update
result = NorthwindAdoRepository.ExecuteEntity("SaveOrUpdateCategory", category, nameMapper);
Assert.IsTrue(result.AsInt() > 0);
}
