public IEnumerable <TResultTable> GetDataFromStoredProcedureAccessor(Database database, object[] param, IRowMapper <TResultTable> mapper)
{
IParameterMapper paramMapper = new SimpleParameterMapper();
DataAccessor <TResultTable> accessor =
database.CreateSprocAccessor(storedProcedureName, paramMapper, mapper);
return(accessor.Execute(param));
}
public void RunAsync(Database database, object[] param, IRowMapper <TResultTable> rowMapper)
{
try
{
IParameterMapper paramMapper = new SimpleParameterMapper();
DataAccessor <TResultTable> accessor =
database.CreateSprocAccessor(StoredProcedureName, paramMapper, rowMapper);
// Execute the accessor asynchronously, passing in the callback handler,
// the existing accessor as the AsyncState, and the parameter values.
IAsyncResult async = accessor.BeginExecute(MyEndExecuteCallback, accessor, param);
}
catch
{
// handle any execution initiation errors here
}
}