What is optimistic concurrency?
How to implement it?
- Assumes conflicts are rare; detects conflicts when saving.
- Uses concurrency tokens (e.g., timestamp or row version) to detect if data was
changed by another process.
- EF Core throws DbUpdateConcurrencyException if a conflict occurs.