conn.Open(); OracleTransaction tx = conn.BeginTransaction(); try OracleCommand cmd = conn.CreateCommand(); cmd.Transaction = tx; cmd.CommandText = "UPDATE accounts SET balance = balance - 100 WHERE id = 1"; cmd.ExecuteNonQuery(); cmd.CommandText = "UPDATE accounts SET balance = balance + 100 WHERE id = 2"; cmd.ExecuteNonQuery(); tx.Commit(); catch tx.Rollback(); throw;
For legacy systems already using Oracle.DataAccess , maintain it with proper connection handling, parameterization, and transaction management to ensure stability and performance. Last updated: 2025 Oracle.DataAccess version coverage: 4.112.x to 4.122.x (for .NET Framework)
conn.Open(); OracleCommand cmd = new OracleCommand("GET_EMPLOYEES_BY_DEPT", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("p_dept_id", OracleDbType.Int32).Value = 30; cmd.Parameters.Add("p_cursor", OracleDbType.RefCursor).Direction = ParameterDirection.Output; using (OracleDataReader reader = cmd.ExecuteReader()) oracle.dataaccess
DataTable dt = new DataTable(); // ... fill DataTable using (OracleConnection conn = new OracleConnection(connStr))
conn.Open(); using (OracleBulkCopy bulkCopy = new OracleBulkCopy(conn)) OracleTransaction tx = conn.BeginTransaction()
while (reader.Read()) Console.WriteLine(reader["last_name"]);
using (OracleConnection conn = new OracleConnection(connStr)) try OracleCommand cmd = conn.CreateCommand()
.NET App → Oracle.DataAccess.dll → Oracle Client → SQL*Net → Oracle Database