python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - optimistic-concurrency

Optimistic concurrency while in transaction

In trying to fix data errors due to concurrency conflicts I realized I'm not completely sure how optimistic concurrency works in SQL Server. Assume READ_COMMITTED isolation level. A similar example: B...
test-img

Max

sql

sql-server

optimistic-concurrency

Votes: 0

Answers: 1

Latest Answer

I think what you want to do is remove the very small race condition in your script by making it as set based as possible, e.g. BEGIN TRAN DECLARE @UpdatedSources Table (Key INT NOT NULL); UPDATE s S...
test-img

Paddy

Handling concurrency condition in entity framework core to prevent race condition

I am trying to run a test case and trying to pass two schedules inside like below: var itemToAdd = new ScheduleInputItemDto { Start = DateTime.UtcNow, End = DateTime.UtcNow.AddHou...
test-img

Priom Biswas

c#

asp.net

entity-framework-core

optimistic-concurrency

pessimistic-locking

Votes: 0

Answers: 2

Latest Answer

In summary, when using a database with multiple actors (e.g. threads, requests), it is hard to ensure that the data doesn't change between a read (required for validation) and a write (insert/update)....
test-img

tymtam

Posts

Questions

Blogs

Jobs