Category Archives: LINQ

Resolving the concurrency conflicts in LINQ using Transactions

As we were discussing concurrency options in my previous articles here , we noted that updating the database with SubmitChanges could update a single record or any number of records (even across multiple tables). If we run into conflicts, we … Continue reading

Posted in .NET Framework, LINQ | 1 Comment

Handling Concurrency in LINQ to SQL -Part 3

In my earlier articles I showed how we can handle the concurrency using UpdateCheck. In this articles I will show how to deal with Concurrency Exceptions. In using the Always or WhenChanged options for UpdateCheck, it is inevitable that two users … Continue reading

Posted in .NET Framework, LINQ | Leave a comment

Handling Concurrency in LINQ to SQL -Part 2

In my earlier article here I showed you how to reproduce the concurreny issues in LINQ to SQL. In this article and in the subsequent articles I will write more about how to resolve the conflicts arising out of these … Continue reading

Posted in LINQ | Leave a comment

Handling Concurrency in LINQ to SQL-Part 1

  In a typical production system which is used by multiple users at the same time, we need to take into account the conflicts that arise when two users try to change the same record at the same time. These … Continue reading

Posted in .NET Framework, LINQ | Leave a comment