Tag Archives: SQL_Server

Avoid unwanted Escalation to Distributed Transactions

When working with the .NET TransactionScope we want to use simple, lightweight, (local) transactions and avoid  escalating to distributed transactions if possible. This is not a problem when using SQL Server 2008+ and not nesting connections but if you are … Continue reading

Posted in Computers and Internet | Tagged , , , , , , | 12 Comments

DB Concurrency Control with .NET – Overview

This (long) posting provides guidelines for using common patterns to control concurrency when using relational databases (RDBMS) via ADO.NET or the .NET Entity Framework (EF). MS SQL Server and Oracle are used as examples to sensitize you for the implications … Continue reading

Posted in Computers and Internet | Tagged , , , , , , , , , | 3 Comments