Enum LockWaitMode
How a row lock behaves when the requested row is already locked by another transaction.
public enum LockWaitMode
- Extension Methods
Fields
NoWait = 1Fail immediately instead of waiting (
NOWAIT; SQL ServerNOWAITtable hint).SkipLocked = 2Skip rows locked by other transactions instead of waiting (
SKIP LOCKED; SQL ServerREADPAST).Wait = 0Block until the lock can be acquired (the default; no wait-mode suffix is emitted).