CODEWITHSUNDEEP
asp.netsqlado.netsql-server-2012
Imran Qadir Baksh - Baloch
Imran Qadir Baksh - Baloch

Reputation: 34034

No Read Committed Snapshot in ADO.NET Isolation Level?

Checking the ADO.NET IsolationLevel, I have found that there is no Read_Commited_Snapshot. How to set this level of IsolationLevel using ADO.NET

Upvotes: 2

Views: 325

Answers (1)

JFM
JFM

Reputation: 763

Read_Commited_Snapshot is not an isolation level, its a database option which makes statements with the read committed isolationlevel using row versioning. I don't think you should set that in ADO.net. Rather set it in the SQL Server environment by sqlcmd or SSMS, ADO.Net will use the read committed by default so there's probably no need for changes of the transatiction level at all.

Upvotes: 2

Related Questions