AcessoDados.rpLerDados.ExecutarComandoSQL C# (CSharp) Метод

        public Int32 ExecutarComandoSQL(string xQuery, string NomeTabela, string ConexaoOracle)
        {
            Int32 RetornoLinhas = 0;

            //OracleConnection DB = new OracleConnection(DecriptaString(ConexaoOracle));
            //OracleCommand Cmd = new OracleCommand();

            //DB.Open();

            //Cmd.Connection = DB;
            //Cmd.CommandText = xQuery;

            //RetornoLinhas = Cmd.ExecuteNonQuery();

            //DB.Close();
            //DB.Dispose();

            SqlConnection DB = new SqlConnection(DecriptaString(ConexaoOracle));
            SqlCommand Cmd = new SqlCommand();

            DB.Open();

            Cmd.Connection = DB;
            Cmd.CommandText = xQuery;

            RetornoLinhas = Cmd.ExecuteNonQuery();

            DB.Close();
            DB.Dispose();

            return RetornoLinhas;
        }