public static Dictionary <string, object> ExecuteStoreProcedure(string spName, DataAccessParameterCollection parameters) { using (DataAccessBroker broker = DataAccessFactory.Instance()) { return(broker.ExecuteProcReturnOutput(spName, parameters)); } }
public static Dictionary <string, object> ExecuteProcReturnOutput(DataAccessBroker broker, string commandString, DataAccessParameter[] dps) { DataAccessParameterCollection dpc = new DataAccessParameterCollection(); if (dps != null && dps.Length > 0) { foreach (DataAccessParameter dp in dps) { dpc.Add(dp.ParameterName, dp); } } return(broker.ExecuteProcReturnOutput(commandString, dpc)); }