Implicit transactions

JORGEMAL · Post by **JORGEMAL** » Mon 21 Nov 2011 23:24

PostgreSQL 9.0 documentation says the following about transactions:

"PostgreSQL actually treats every SQL statement as being executed within a transaction. If you do not issue a BEGIN command, then each individual statement has an implicit BEGIN and (if successful) COMMIT wrapped around it."

Does this apply for dotConnect for PostgreSQL provider?

Respectfully,
Jorge Maldonado

Shalex · Post by **Shalex** » Wed 23 Nov 2011 14:11

This is true if you are not using local (PgSqlConnection.BeginTransaction()) or distributed (TransactionScope) transactions. Because in case of explicit transactions you determine in your code yourself when transaction has to be started and committed.