AutoCommit and Transactions

// Connection string: AutoCommit=true (default), UseArrayBinding=true
using (var scope = new TransactionScope(TransactionScopeOption.Suppress))
{
    using var conn = new OracleConnection(connStr);
    conn.Open();

    AuditInsert(conn);               // Normal DML: auto-commit

    conn.AutoCommit = false;         // Set after connecting to meet the prerequisite for ArrayBinding.
    ArrayBindInsert(conn);
    conn.AutoCommit = true;          // Required: Commit the batch and restore automatic commit.

    scope.Complete();
}

conn.Open();                         // Connection string AutoCommit=true

UpdateMainTable(conn);               // Single UPDATE, already automatically committed

conn.AutoCommit = false;
ArrayBindDetailRows(conn);
conn.AutoCommit = true;              // Commit detail batch

conn.AutoCommit = false;             // Must be done before BeginTransaction
using (var tx = conn.BeginTransaction())
{
    UpdateMainTable(conn, tx);
    ArrayBindDetailRows(conn, tx);
    tx.Commit();
}
conn.AutoCommit = true;