Oracle.dataaccess [RECOMMENDED]

while (reader.Read()) Console.WriteLine($"reader["first_name"] reader["last_name"]");

using (OracleDataReader reader = cmd.ExecuteReader()) oracle.dataaccess

.NET App → Oracle.DataAccess.dll → Oracle Client → SQL*Net → Oracle Database while (reader

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; OracleTransaction tx = conn.BeginTransaction()