Hamekoz.Data.DB.SqlToDataSet C# (CSharp) Method

        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;
                    }
                }
            }
        }