All geek questions in one place

Why is the TransactionScope default constructor used?

Why is it harmful to use the default TranscationScope constructor?

Can someone point me to this explanation?

+4
source share
1 answer

Read this MSDN blog post with the new TransactionScope () constructor .

Excerpts:

The default constructor, TransactionScopes, is used for SQL Server Server Deployment purposes. TransactionScopes default default constructor sets the isolation level to Serializable and timeout up to 1 minute. IMO both of these settings are harmful when working against SQL Server.

A transaction timeout is bad because it is unclear. A SqlCommand already has a CommandTimeout property, which by default is 30 seconds. If you explicitly extend CommandTimeout to SqlCommand, its probably unexpected that your transaction will timeout before that. But at least the default timeout can be changed in the application configuration file.

+4
source

Source: https://habr.com/ru/post/1369070/

More articles:


All Articles