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

        public string RetornarConsulta(string xQuery, string NomeTabela, string ConexaoOracle)
        {
            string Resposta = "0";

            SqlConnection DB = new SqlConnection(DecriptaString(ConexaoOracle));
            SqlCommand Cmd = new SqlCommand();
            SqlDataReader Dre;
            DB.Open();

            Cmd.Connection = DB;
            Cmd.CommandText = xQuery;
            Dre = Cmd.ExecuteReader();

            if (Dre.Read())
            {
                Resposta = Dre[0].ToString();
            }

            //Resposta = Cmd.ExecuteScalar(); //ANTIGO

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

            return Resposta;
        }