using (MercatorSqlConnection conn = new MercatorSqlConnection(Globals.RepData, true))
{
    if (conn.Connection == null)
        return;
    using (SqlTransaction transac = conn.Connection.BeginTransaction())
    {
        using (SqlCommand cmd = new SqlCommand("update ... delete ...", conn.Connection, transac))
        {
            if (!Api.SqlExec(cmd))
                Api.SafeRollback(transac);
            else
                Api.SafeCommit(transac);
        }
    }
}