CODEWITHSUNDEEP
c#sql-serverlinqlinq-to-sql
frosty
frosty

Reputation: 2862

LINQ To SQL: Setting READ UNCOMMITTED isolation globally on querying

My application does CRUD operations on SQL Server database using LINQ. For read operations, it is okay to do dirty reads. Instead of setting TransactionScope on each read method, is there a global way to set dirty reads for reads without messing up write operations? Note that there are hundreds of read methods doing join across multiple tables.

Upvotes: 0

Views: 331

Answers (1)

Matt Ko
Matt Ko

Reputation: 979

as described on this blog, there isn't a supported way to do this. You'll have to do it for each transaction.

Upvotes: 1

Related Questions