Hello,

1) After adapter.StartTransaction(..), the first Rollback or Commit encountered will prevent the adapter instance from being used again. Is this correct?

If the adapter is initialized with keepConnectionOpen = true, then multiple Commit and RollBack calls will work until adapter.Dispose() is reached. Is this correct?

2) Should this code only Rollback to after the Commit statement?

adapter.SaveEntity(..); // save #1 adapter.Commit(); adapter.SaveEntity(..); // save #2 try { something} catch { adapter.RollBack(); // does this only RollBack save #2?}

1) No the adapter can be used after this time. The connection will simply be re created for any new requests

Note CloseConnection should reallly be used rather than Dispose if KeepConnectionOpen is used.

2) No, because StartTransaction hasn't been called after the first commit, the RollBack call will simply return because there is no transaction to roll back

You can of course create save points and then roll back to those specific save points.

MattAdamson wrote:

1) No the adapter can be used after this time. The connection will simply be re created for any new requests

Note CloseConnection should reallly be used rather than Dispose if KeepConnectionOpen is used.

2) No, because StartTransaction hasn't been called after the first commit, the RollBack call will simply return because there is no transaction to roll back

You can of course create save points and then roll back to those specific save points.

Thanks, these points are clear.

Regarding #1. If Connection Pooling is being used, the cost of re-opening a connection (KeepConnectionOpen = false) will be greatly reduced, correct?

Correct. Taking a connection from a connection pool is just a few ms.