Search code examples
sqllinq-to-sqllockingdatacontextlinqdatasource

How to lock a SQL record with LinqToSql?

I'm using a LinqToSql DataContext and I want to lock a record for being opened in write mode. Meaning while one user in Hong Kong has a record open in write mode, another user in France can't open that record in write mode. How?

Solution

  • LinqToSql supports optimistic concurrency, not pessimistic concurrency.