public void ResultsAreReturnedWhenExecutingStoredProcrocAccessorWithCustomResultSetMapper()
{
Database db = new DatabaseProviderFactory(base.ConfigurationSource).CreateDefault();
var accessor = new SprocAccessor <TopTenProduct>(db, "Ten Most Expensive Products", new TopTenProductResultSet());
var results = accessor.Execute().ToList();
Assert.AreEqual(2, results.Count);
Assert.AreEqual("Côte de Blaye", results[0].TenMostExpensiveProducts);
Assert.AreEqual(263.50M, results[0].UnitPrice);
}
public void ResultsAreReturnedWhenExecutingStoredProcrocAccessorWithParametersAndParameterMapper()
{
Database db = new DatabaseProviderFactory(base.ConfigurationSource).CreateDefault();
var accessor = new SprocAccessor <CategoryBySale>(db, "SalesByCategory", new GetCategoryByIdParameterMapper(), new CategoryRowMapper());
var results = accessor.Execute(new object[2] {
"Beverages", "1998"
});
var category = results.First();
Assert.AreEqual("Chai", category.ProductName);
Assert.AreEqual(6296.00M, category.TotalPurchase);
}
