tags:

views:

36

answers:

1
+1  Q: 

Using SQL Will Fix Concurrency Issues?

I am developing a set of applications that all hit the same database, and concurrency has been one of the biggest issues I've had to deal with.

I'm developing solutions to work around these issues, and I recently thought of using SQL queries instead of LINQ queries to update databases. Because SQL has pessimistic concurrency control, in terms of preventing concurrency issues, is this a good and simple solution to my LINQ concurrency woes?

+1  A: 

Linq just passes SQL statements to SQL Server. So it could very well be sending SQL Server the same statements you would be generating. And besides, SQL Server uses optimistic concurrency. So I think you have other issues.

Randy Minder  2010-07-09 18:31:43
and so, just using SQL really doesn't make any positive difference....
marc_s  2010-07-09 18:32:41
@marc_s - Using SQL or Linq wouldn't make any difference, IMO.
Randy Minder  2010-07-09 18:33:44

related questions

How to find an implementation of a C# interface in the current assembly with a specific name?
Learning about LINQ
LINQ to SQL Mapping From Money to Double
SQL Server 2008 vs 2005 Linq integration
Aging Data Structure in C#
LINQ-to-SQL vs stored procedures?
LINQ, entity that implements Interface and exception in mapping
How can I remove nodes from a SiteMapNodeCollection?
Conditional Linq Queries
LINQ query on a DataTable
Expression.Invoke in Entity Framework?
How to return a page of results from SQL?
Import Namespace System.Query
Has anyone run performance benchmarks comparing LINQ
Beginners Guide to LINQ
Querying like Linq when you don't have Linq.
Linq to objects - select first object
C# 3.0 Where extension method with lambda vs LINQtoObjects to filter in memory collections.
How much database performance overhead when using LINQ?
LinqDataSource - Can you limit the amount of records returned?
LINQ on the .NET 2.0 Runtime
How do I most elegantly express left join with aggregate SQL as LINQ query
How do you page a collection with LINQ?
How do I get a distinct, ordered list of names from a DataTable using Linq
How do I fill a DataSet or a DataTable from a LINQ query resultset ?