/// <summary>
/// This method help to execute store procedure by store name without parameter. Reutrn multiple result set
/// </summary>
/// <param name="context">Database context</param>
/// <param name="storeName">Store name for execution</param>
/// <param name="parameters">Array of parameters</param>
/// <returns>Wrapper for multiple result set</returns>
public static MultipleResultSetWrapper ExecuteStoreProcedureMultipleResultSet(this DbContext context, string storeName, params SimpleSqlParam[] parameters)
{
List <SqlParameter> sqlParameters = new List <SqlParameter>();
foreach (SimpleSqlParam param in parameters)
{
SqlParameter sqlParameter = new SqlParameter
{
ParameterName = param.Name,
Value = param.Value
};
sqlParameters.Add(sqlParameter);
}
MultipleResultSetWrapper wrapper = new MultipleResultSetWrapper(context, storeName, sqlParameters.ToArray());
return(wrapper);
}
/// <summary>
/// This method help to execute store procedure by store name without parameter. Reutrn multiple result set
/// </summary>
/// <param name="context">Database context</param>
/// <param name="storeName">Store name for execution</param>
/// <param name="parameters">Array of parameters</param>
/// <returns>Wrapper for multiple result set</returns>
public static MultipleResultSetWrapper ExecuteStoreProcedureMultipleResultSet(this DbContext context, string storeName, params SqlParameter[] parameters)
{
MultipleResultSetWrapper wrapper = new MultipleResultSetWrapper(context, storeName, parameters);
return(wrapper);
}
/// <summary>
/// This method help to execute store procedure by store name without parameter. Reutrn multiple result set
/// </summary>
/// <param name="context">Database context</param>
/// <param name="storeName">Store name for execution</param>
/// <param name="parameters">Array of parameters</param>
/// <returns>Wrapper for multiple result set</returns>
public static MultipleResultSetWrapper ExecuteStoreProcedureMultipleResultSet(this DbContext context, string storeName)
{
MultipleResultSetWrapper wrapper = new MultipleResultSetWrapper(context, storeName, null);
return(wrapper);
}
