public DataSet ExecuteStoredProcedure(IStoredProcedureQueryWithResults procedure, IConnectionSetting connectionSetting)
{
DataSet dataset = new DataSet();
using (SqlConnection con = new SqlConnection(connectionSetting.GetDataSourcePath()))
{
SqlCommand command = new SqlCommand(procedure.StoredProcedureName, con);
foreach (var parameter in procedure.Parameters)
{
command.Parameters.AddWithValue(parameter.Key, parameter.Value);
}
command.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = command;
da.Fill(dataset);
return(dataset);
}
}
public DataSet GetSqlDataSet(IStoredProcedureQueryWithResults storedProcedure, IConnectionSetting connectionSetting)
{
return(new SqlExecutor().ExecuteStoredProcedure(storedProcedure, connectionSetting));
}
