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.