C#

Dave Kreskowiak wrote:

You cannot mute individual processes.

DbTransaction tran = conn.BeginTransaction();

DbConnection conn = GetConnection();
DbTransaction tran = conn.BeginTransaction();
bool success = true;
...
success = MethodA(conn, tran);
success = success && MethodB(conn, tran);
success = success && MethodC(conn, tran);
if(!success)
    tran.Rollback();
else
    tran.Commit();
...

private bool MethodA(DbConnection conn, DbTransaction tran)
{
    bool result = true;
    DbCommand comm = conn.CreateCommand();
    comm.CommandText = ...
    comm.Transaction = tran;
    ...
    return result;
}
...
private bool MethodB(DbConnection conn, DbTransaction tran)
...
private bool MethodC(DbConnection conn, DbTransaction tran)
...