// Example 1: INSERT statement using System.Data.OracleClient; string connectionString = "Data Source=myOracleDB;User Id=myUsername;Password=myPassword;"; string sql = "INSERT INTO employees (employee_id, first_name, last_name) VALUES (1, 'John', 'Smith')"; using (OracleConnection connection = new OracleConnection(connectionString)) { connection.Open(); using (OracleCommand command = connection.CreateCommand()) { command.CommandText = sql; command.ExecuteNonQuery(); } } // Example 2: SELECT statement using System.Data.OracleClient; string connectionString = "Data Source=myOracleDB;User Id=myUsername;Password=myPassword;"; string sql = "SELECT employee_id, first_name, last_name FROM employees WHERE employee_id = 1"; using (OracleConnection connection = new OracleConnection(connectionString)) { connection.Open(); using (OracleCommand command = connection.CreateCommand()) { command.CommandText = sql; using (OracleDataReader reader = command.ExecuteReader()) { while (reader.Read()) { int employeeId = reader.GetInt32(0); string firstName = reader.GetString(1); string lastName = reader.GetString(2); Console.WriteLine("Employee ID: {0}, First Name: {1}, Last Name: {2}", employeeId, firstName, lastName); } } } }In both examples, we first create an OracleConnection object and open a connection to the database using the connection string. We then create an OracleCommand object using the CreateCommand method and set its CommandText property to our SQL statement. In the INSERT example, we then call the ExecuteNonQuery method to run the SQL statement. In the SELECT example, we call the ExecuteReader method which returns an OracleDataReader object that we can use to iterate over the results of our query. The System.Data.OracleClient package library is included in the .NET Framework and is available on Windows platform. However, Microsoft has recommended alternative libraries such as Oracle’s ODP.NET and Oracle’s ManagedDataAccess.Client libraries, which will be supported moving forward.