© 2026 Hedgehog Software, LLC
Twitter
GitHub
Discord
System
Light
Dark
More
Communities
Docs
About
Terms
Privacy
Search
Star
Feedback
Setup for Free
Isolation level for reading a row only once - C#
C
C#
•
2y ago
•
3 replies
Core
Isolation level for reading a row only once
Hi
,
I need to select the first row from a table where a column value is equal to
false
false
and also modify it to
true
true
. This means
, if many request come at the same time
(they do
)
, no 2 SELECT statements should get the same row
.
I am sure a distributed lock would solve the problem
, but I was wondering if a transaction isolation level would be enough
.
Would
Serializable
Serializable
isolation level be ideal for this use case
?
C#
Join
We are a programming server aimed at coders discussing everything related to C# (CSharp) and .NET.
62,338
Members
View on Discord
Resources
ModelContextProtocol
ModelContextProtocol
MCP Server
Similar Threads
Was this page helpful?
Yes
No
Recent Announcements
Similar Threads
Need to only pick a a number Once
C
C# / help
2y ago
❔ ✅ HttpListener only receives context once
C
C# / help
4y ago
Reading HTTP requests on machine level
C
C# / help
2y ago
❔ SQL Statement only returning one row
C
C# / help
3y ago