public DataSet SPToDataSet(DataSet dataset, string sp, params object[] parameters)
{
using (DbConnection conexion = factory.CreateConnection ()) {
conexion.ConnectionString = ConnectionString;
conexion.Open ();
using (DbCommand comando = factory.CreateCommand ()) {
comando.Connection = conexion;
comando.CommandType = CommandType.StoredProcedure;
comando.CommandText = sp;
comando.CommandTimeout = CommandTimeOut;
cargarParametros (comando, parameters);
using (DbDataAdapter adaptador = factory.CreateDataAdapter ()) {
adaptador.SelectCommand = comando;
adaptador.Fill (dataset, sp);
return dataset;
}
}
}
}