Working with concurrency and transactions

When you're working in a multi-user environment, concurrency is something that needs to be taken into account. What happens when two or more users update the same row? Transactions are equally important. If you've got a bunch of Entities that need updating, should they be updated in one transaction, or should updates happen one by one? This recipe will explain the possibilities you get for managing your own concurrency and transaction behavior.

Getting ready

This recipe uses the AdventureWorks Lite database—a free database you can download from To follow this recipe, you need to have this database installed on an SQL Server instance you can access from your machine. ...

Get Silverlight 4 Data and Services Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.