Get connection state and server version : Oracle « ADO.Net « C# / CSharp Tutorial

1. C# / CSharp Tutorial
2. ADO.Net
3. Oracle

using System;
using System.Data.OracleClient;

  class Class1
  {
    static void Main(string[] args)
      {
            String connString = "User Id=oranetuser;Password=demo";
            OracleConnection oraConn = new OracleConnection(connString);

            try
            {
                oraConn.Open();
                Console.WriteLine(oraConn.ConnectionString.ToString() + "\n");
                Console.WriteLine(oraConn.State.ToString() + "\n");
                Console.WriteLine(oraConn.ServerVersion.ToString());
            }
            catch (Exception ex)
            {
                Console.WriteLine("Error occured: " + ex.Message);
            }
            finally
            {
                if (oraConn.State == System.Data.ConnectionState.Open)
                {
                    oraConn.Close();
                }
            }
    }
  }