What is a common mistake with transactions and optimistic concurrency in Entity Framework Core?

Long transactions increase locking, while ignoring concurrency tokens can silently overwrite another user’s work. In practice, the value of this concept comes from understanding where it belongs in the architecture, what problem it solves, and what constraints or tradeoffs it introduces.