AutoTransactionBehavior

WhenNeeded

const

Transactions are automatically created as needed. For example, most single SQL statements are implicitly executed within a transaction, and so do not require an explicit one to be created, reducing database round trips. This is the default setting.

Always

const

Transactions are always created automatically, as long there's no user transaction. This setting may create transactions even when they're not needed, adding additional database round trips which may degrade performance.

Never

const

Transactions are never created automatically. Use this options with caution, since the database could be left in an inconsistent state if a failure occurs.