LINQ + TransactionScope will not change isolation level in SQL Server Profiler

Hi Guys, I'm using the following format for commiting changes to my db using linq.

Begin Transaction (Scope Serialized, Required)
    Check Business Rule 1...N
    MyDataContext.SubmitChanges()
    Save Changes Done In Previous Query To Log File
End Transaction Scope

But in the SQL Server profiler I see the following line in the Connection:Start.

set transaction isolation level read committed

I went through this (http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/thread/93a45026-0425-4d49-a4ac-1b882e90e6d5) and thought I had an answer;

Until I saw this (https://connect.microsoft.com/VisualStudio/feedback/details/565441/transactionscope-linq-to-sql?wa=wsignin1.0) on Microsoft Connect.

Can someone please tell me whether my code is actually executed under Serialized Isolation Level or whether it is infact just running under read committed?

ansaurus

tags:

views:

answers:

LINQ + TransactionScope will not change isolation level in SQL Server Profiler

related questions