How should connection resiliency and transient retries be designed for production in Entity Framework Core?

Retry only transient errors, keep operations idempotent where possible, add observability, and avoid long-lived manual connections. 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.