C# OracleHelper

 public static class OracleHelper
    {
        public static string GetConnectionString()
        {

                string WMS_ip =  ConfigurationManager.AppSettings["WMS_ip"].ToString();
               string WMS_user = ConfigurationManager.AppSettings["WMS_user"].ToString();
               string WMS_pass = ConfigurationManager.AppSettings["WMS_pass"].ToString();
               string WMS_DB =   ConfigurationManager.AppSettings["WMS_DB"].ToString();            
               string WMS_Prot = ConfigurationManager.AppSettings["WMS_Prot"].ToString();

            return $"User Id={WMS_user};Password={WMS_pass};Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST={WMS_ip})(PORT={WMS_Prot})))(CONNECT_DATA=(SERVICE_NAME={WMS_DB})))";

        }

        public static DataTable ExecuteDataTable(string sql, params OracleParameter[] parameters)
        {
               
            using (OracleConnection conn = new OracleConnection(GetConnectionString()))
            {
                conn.Open();
                using (OracleCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = sql;
                    cmd.Parameters.AddRange(parameters);
                    OracleDataAdapter adapter = new OracleDataAdapter(cmd);
                    DataTable datatable = new DataTable();
                    adapter.Fill(datatable);
                    return datatable;
                }
            }
        }

    }
}