Tag Archives: Transaction_Scope

Managing BLOBs using SQL Server FileStream via EF and WCF streaming

Für mehr Informationen zu diesem Thema in Deutsch siehe meinen Artikel “Stream das BLOB” im dotnetpro Magazin 6/2012. With FileStream SQL Server 2008+ stores BLOBs in the NTFS file system instead of its table store and offers fast streaming access. … Continue reading

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

DB Concurrency Control with .NET – Details

[To put this post into perspective see DB Concurrency Control with .NET – Overview] The following patterns are commonly used in applications to control database concurrency: Optimistic Control in UI Scenarios in Service Scenarios Pessimistic Control SQL Locking Hints Check-out Locking … Continue reading

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

Use the .NET TransactionScope

The TransactionScope class provides an elegant way to enclose a set of operations against resource managers in a transaction. Resource managers are: Databases (SQL Server, Oracle, DB2, …) MSMQ Transactional NTFS file system TxF Transactional Registry Custom resource managers See … Continue reading

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

Avoid unwanted Escalation to Distributed Transactions

[editing in progress!] 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 … Continue reading

Posted in Computers and Internet | Tagged , , , , , , | 8 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