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.
This recipe uses the AdventureWorks Lite database—a free database you can download from http://www.codeplex.com/MSFTDBProdSamples. To follow this recipe, you need to have this database installed on an SQL Server instance you can access from your machine. ...