L的筆記本: C#

EF6新增Database.BeginTransaction()
Working with Transactions (EF6 Onwards)
Entity Framework (EF) TransactionScope vs Database.BeginTransaction
Transaction Support in Entity Framework 6
What's the point of an explicit database transaction in Entity Framework 6?

使用前必需詳閱說明：
使用交易範圍實作隱含交易
根據預設，交易會在隔離等級設為 Serializable 時執行。在讀取頻繁的系統上，常常會選取使用 Serializable 以外的隔離等級。

11.TRANSACTION ISOLATION LEVEL *****
All About TransactionScope *****
What is default IsolationLevel for TransactionScope?
.NET TransactionScope and its default Transaction Isolation level issue

Transactions and Connections in Entity Framework 4.0 *****

using new TransactionScope() Considered Harmful *****

Why is System.Transactions TransactionScope default Isolationlevel Serializable

Deadlocks w/Entity Framework - how to rerun the transaction?
Quote from Ladislav Mrnka:

Default isolation level for TransactionScope is serializable which is the most restrictive level for transaction (= causes deadlock more often). You should start by using Read committed isolation level (but you must ensure that same data are not read multiple times from the database during a transaction) to reduce database locking but it will most probably doesn't solve the problem (it can reduce the frequency)

目前用法：

using (var ts = new TransactionScope(TransactionScopeOption.Required, 
     new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted }))
{
     //TODO
     ts.Complete();
}

TimeOut 預設1分鐘，最大10分鐘。
All About TransactionScope *****
using new TransactionScope() Considered Harmful ***
Changing TransactionScope - Timeout at runtime
Transaction scope timeout on 10 minutes
Transactionscope timeout max is only 10 mins

Introducing System.Transactions in the .NET Framework 2.0

確保交易的新利器(TransactionScope)初體驗
KB-.NET 2.0 分散式交易新利器---TransactionScope
TransactionScope與COMMIT TRAN

.NET分散式交易程式開發FAQ
多重TransactionScope與TransactionScopeOption

Nesting Transactions with a Single SQL Server Database

[IIS] 啟用Microsoft 分散式交易協調器(MSDTC)服務

ORA-02089: COMMIT is not allowed in a subordinate session

與目前連接關聯的交易已完成，但尚未處置。必須先處置交易，才能使用連接來執行 SQL 陳述式。
The transaction associated with the current connection has completed but has not been disposed. The transaction must be disposed before the connection can be used to execute SQL statements.
設定timeout

L的筆記本

搜尋此網誌

2099-12-31

Code Style Guide

2018-03-14

Serilog

2017-03-24

ConfigurationManager & 組態檔

2016-12-06

OAuth

2016-11-08

Google API

2016-10-07

HttpWebRequest WebClient HttpClient

2016-09-20

Xamarin 開發資源

2016-08-29

.Net 讀寫 Excel, XML, PDF

2016-08-04

TransactionScope

2016-06-10

Data Annotation

2016-04-24

LINQPad Snippets

2016-04-19

Lambda GroupBy Rank

2015-06-17

TDD

2015-06-04

Unity

2015-05-25

Reflection

2015-05-15

Repository

2015-02-12

Logging

2015-02-11

MEF

C# 程式設計參考資源