public void ConvertAllFromDataTableByConverter(int firstResult, int maxResults)
{
Func <DataRow, CustomerOrderHistory> @mapFunc =
row =>
new CustomerOrderHistory {
ProductName = row["PRODUCTNAME"].AsText(),
Total = row["TOTAL"].AsIntNullable()
};
using (var dt = NorthwindAdoRepository.ExecuteDataTableByProcedure("CustOrderHist",
firstResult,
maxResults,
CustomerTestParameter)) {
Assert.IsFalse(dt.HasErrors);
Assert.Greater(dt.Rows.Count, 1);
var orderHistories = AdoTool.Map(dt, @mapFunc);
if (IsDebugEnabled)
{
log.Debug(orderHistories.CollectionToString());
}
Assert.Greater(orderHistories.Count, 0);
}
}
public void ConvertAllFromDataTable(int firstResult, int maxResults)
{
using (var dt = NorthwindAdoRepository.ExecuteDataTableByProcedure("CustOrderHist",
firstResult,
maxResults,
CustomerTestParameter)) {
Assert.IsFalse(dt.HasErrors);
Assert.Greater(dt.Rows.Count, 1);
var orderHistories = AdoTool.Map <CustomerOrderHistory>(dt);
if (IsDebugEnabled)
{
log.Debug("OrderHistories:" + orderHistories.CollectionToString());
}
Assert.Greater(orderHistories.Count, 0);
}
}
public void ConvertAllFromDataTableByNameMappingFuncs(int firstResult, int maxResults)
{
// CustOrderHist2 Procedure를 만들어야 한다. (Column 명을 대문자, '_'로 바꾼다. 즉 PRODUCT_NAME, TOTAL 로 column명만 바꾼다
using (var dt = NorthwindAdoRepository.ExecuteDataTableByProcedure("CustOrderHist2",
firstResult,
maxResults,
CustomerTestParameter)) {
Assert.IsFalse(dt.HasErrors);
Assert.Greater(dt.Rows.Count, 1);
var orderHistories =
AdoTool.Map <CustomerOrderHistory>(dt,
dt.Mapping(NameMappingUtil
.CapitalizeMappingFunc('_', ' ')));
if (IsDebugEnabled)
{
log.Debug(orderHistories.CollectionToString());
}
Assert.Greater(orderHistories.Count, 0);
}
}
