コード例 #1
0
        public object GetStructureDB()
        {
            //SalvaLog
            log.Trace(this.getJsonStructureDB());

            if (_tipoBD == SistemasModel.TipoServidorBD.SqlServer.ToString())
            {
                ExecuteSqlServer client = new ExecuteSqlServer(_connString);
                return(client.GetDBStructure());
            }
            else if (_tipoBD == SistemasModel.TipoServidorBD.Oracle.ToString())
            {
                ExecuteOracle client = new ExecuteOracle(_connString);
                return(client.GetDBStructure());
            }
            else
            {
                return(new
                {
                    msg = "Database not supported"
                });
            }
        }
コード例 #2
0
        public object ExecuteQuery(string query, string fileName = "", bool saveFile = false)
        {
            //SalvaLog
            log.Trace(this.getJsonExecutaQuery(query, fileName, saveFile));

            if (_tipoBD == SistemasModel.TipoServidorBD.SqlServer.ToString())
            {
                ExecuteSqlServer client = new ExecuteSqlServer(_connString, saveFile, fileName, _appPath);
                return(client.ExecuteQuery(query));
            }
            else if (_tipoBD == SistemasModel.TipoServidorBD.Oracle.ToString())
            {
                ExecuteOracle client = new ExecuteOracle(_connString, saveFile, fileName, _appPath);
                return(client.ExecuteQuery(query));
            }
            else
            {
                return(new
                {
                    msg = "Database not supported"
                });
            }
        }