How should transactions and optimistic concurrency be designed for production in Entity Framework Core?

Keep transactions short, use rowversion or other concurrency tokens where appropriate, and handle DbUpdateConcurrencyException explicitly.