public DataSet SqlToDataSet(DataSet dataset, string sql)
{
using (DbConnection conexion = factory.CreateConnection ()) {
conexion.ConnectionString = ConnectionString;
conexion.Open ();
using (DbCommand comando = factory.CreateCommand ()) {
comando.Connection = conexion;
comando.CommandType = CommandType.Text;
comando.CommandText = sql;
comando.CommandTimeout = CommandTimeOut;
using (DbDataAdapter adaptador = factory.CreateDataAdapter ()) {
adaptador.SelectCommand = comando;
adaptador.Fill (dataset);
return dataset;
}
}
}
}