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. The implementation should be justified by measurable requirements, kept as simple as the problem allows, and validated with realistic tests, telemetry, failure handling, and documented tradeoffs.