using System.Data.OracleClient; // Establishing a connection to an Oracle database string connectionString = "Data Source=database;User ID=username;Password=password"; using (OracleConnection connection = new OracleConnection(connectionString)) { connection.Open(); // Do database operations }
using System.Data.OracleClient; // Using a connection string from an app.config file string connectionString = ConfigurationManager.ConnectionStrings["OracleConnection"].ConnectionString; using (OracleConnection connection = new OracleConnection(connectionString)) { connection.Open(); // Do database operations }This example shows how to use a connection string stored in an app.config file, which is accessed using the ConfigurationManager.ConnectionStrings property. The connection is then opened and database operations can be performed. Package Library: System.Configuration (for accessing the app.config file), System.Data.OracleClient