public void ExecuteDataSetByProcedure()
{
using (var ds = NorthwindAdoRepository.ExecuteDataSetByProcedure(GetCustomerOrderHistorySql, CustomerTestParameter)) {
Assert.AreEqual(ds.Tables.Count, 1);
Assert.Greater(ds.Tables[0].Rows.Count, 0);
Console.WriteLine("RowCount=[{0}]", ds.Tables[0].Rows.Count);
}
}
public void ExecuteDataSetByProcedure()
{
var spName = NorthwindAdoRepository.QueryProvider.GetQuery("Order, CustomerOrderHistory");
using (var cmd = NorthwindAdoRepository.GetProcedureCommand(spName)) {
using (var ds = NorthwindAdoRepository.ExecuteDataSet(cmd, CustomerTestParameter)) {
Assert.AreEqual(ds.Tables.Count, 1);
Assert.IsFalse(ds.Tables[0].HasErrors);
Assert.Greater(ds.Tables[0].Rows.Count, 0);
}
}
spName = NorthwindAdoRepository.QueryProvider.GetQuery("CustomerOrdersDetail");
using (var ds = NorthwindAdoRepository.ExecuteDataSetByProcedure(spName, OrderTestParameter)) {
Assert.AreEqual(ds.Tables.Count, 1);
Assert.IsFalse(ds.Tables[0].HasErrors);
Assert.Greater(ds.Tables[0].Rows.Count, 0);
}
}