/// <summary>
/// Generic Typed version of calling a stored procedure
/// </summary>
/// <typeparam name="T">Type of object containing the parameter data</typeparam>
/// <param name="context">Database Context to use for the call</param>
/// <param name="procedure">Generic Typed stored procedure object</param>
/// <param name="data">The actual object containing the parameter data</param>
/// <returns></returns>
public static ResultsList CallStoredProc <T>(this DbContext context, StoredProc <T> procedure, T data)
{
IEnumerable <SqlParameter> parms = procedure.Parameters(data);
ResultsList results = context.ReadFromStoredProc(procedure.fullname, parms, procedure.returntypes);
procedure.ProcessOutputParms(parms, data);
return(results ?? new ResultsList());
}
public IEnumerable <TEntity> ExecuteStoredProc <TEntity, TProcArgs>(TProcArgs args)
where TEntity : class
where TProcArgs : IStoredProc, new()
{
var sProc = new StoredProc <TProcArgs>(typeof(TEntity)).HasName(args.StoredProcName);
var resultsSet = DbContext.CallStoredProc <TProcArgs>(sProc, args);
return(resultsSet.ToList <TEntity>());
}
/// <summary>
/// Call a stored procedure, passing in the stored procedure object and a list of parameters
/// </summary>
/// <param name="context">Database context used for the call</param>
/// <param name="procedure">Stored Procedure</param>
/// <param name="parms">List of parameters</param>
/// <returns></returns>
public static ResultsList CallStoredProc(this DbContext context, StoredProc procedure, IEnumerable <SqlParameter> parms = null)
{
ResultsList results = context.ReadFromStoredProc(procedure.fullname, parms, procedure.returntypes);
return(results ?? new ResultsList());
}
