Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Connecting to an Oracle Database with OracleConnection

using System; using System.Data.OracleClient; using System.Data.OleDb; using System.Data.Odbc;     class Program     {         static void Main(string[] args)         {             string oracleConnectString ="Data Source=ORCL;User Id=hr;Password=password;";             using (OracleConnection connection = new OracleConnection(oracleConnectString))             {                 connection.Open(  );                 Console.WriteLine("---Microsoft .NET Provider for Oracle---");                 Console.WriteLine("ConnectionString = {0}\n", oracleConnectString);                 Console.WriteLine("State = {0}", connection.State);                 Console.WriteLine("DataSource = {0}", connection.DataSource);                 Console.WriteLine("ServerVersion = {0}", connection.ServerVersion);             }         }     }