public async Task FillFromProcedureWithDataReaderWithObjectReturnAsync()
{
var da = new SqlDataAccess(ConnectionString);
var helper = new SqlDataAccessHelper();
helper.SetRetrievalMode(DataActionRetrievalType.DataReader);
helper.AddProcedure("sp_help");
var values = await da.FillAsync <DbHelpModel>(helper);
this.OutputTestTimings(helper.ExecutionContext);
Assert.IsTrue(values.Count > 0);
}
public void FillFromProcedureWithDataReaderWithObjectReturnBadProcedureName()
{
var da = new SqlDataAccess(ConnectionString);
var helper = new SqlDataAccessHelper();
helper.SetRetrievalMode(DataActionRetrievalType.DataReader);
helper.AddProcedure("sp_helpxxx");
try
{
var values = da.Fill <DbHelpModel>(helper);
Assert.Fail("Procedure does not exist and should throw an exception");
}
catch (Exception e)
{
Assert.IsTrue(e.Message == "Could not find stored procedure \'dbo.sp_helpxxx\'.");
}
}