Schlagwort-Archive: 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 … Weiterlesen

Veröffentlicht unter Computers and Internet | Verschlagwortet mit , , , , , , | 13 Kommentare

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 … Weiterlesen

Veröffentlicht unter Computers and Internet | Verschlagwortet mit , , , , , , , , , | 3 Kommentare