using System.Data.OracleClient; // Connection string string connectionString = "Data Source=:1521/ ;User ID= ;Password= ;"; // Create connection object OracleConnection connection = new OracleConnection(connectionString); try { // Open the connection connection.Open(); Console.WriteLine("Connection opened."); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { connection.Dispose(); }
using System.Data.OracleClient; // Connection string string connectionString = "Data Source=In this example, a connection to the Oracle database is created using the connection string. An OracleCommand object is created with a SELECT statement to extract data from the database. The command object's Connection property is set to the previously instantiated connection object. The command is then executed with the ExecuteReader method, and the resulting data is read and printed to the console. The data reader is closed, and the connection is finally disposed of.:1521/ ;User ID= ;Password= ;"; // Create connection object OracleConnection connection = new OracleConnection(connectionString); // SqlCommand object OracleCommand command = new OracleCommand(); // Set the command text command.CommandText = "SELECT * FROM employees WHERE department='IT'"; // Set the command connection command.Connection = connection; try { // Open the connection connection.Open(); // Execute the command OracleDataReader reader = command.ExecuteReader(); // Read the data while (reader.Read()) { Console.WriteLine("Name: {0} {1}, Email: {2}", reader["first_name"], reader["last_name"], reader["email"]); } // Close the reader reader.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { connection.Dispose(); }