Connection Pooling and IsolationLevels with SQL Server

Posts   
 
    
paulc
User
Posts: 11
Joined: 03-Oct-2006
# Posted on: 19-Sep-2011 15:45:26   

Does llblgen provide any global way of getting round this "by design" Microsoft bug?: http://support.microsoft.com/?id=972915

When connection pooling is enabled I want all llblgen querys to use ReadCommitted Isolation level unless explicitly told otherwise.

Llblgen may already do this?

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 19-Sep-2011 18:43:22   

By default, LLBLGen Pro uses IsolationLevel.ReadCommitted for the transactions created implicitly by the framework.