What is a common mistake with connection resiliency and transient retries in Entity Framework Core?

Blindly retrying every exception can repeat non-idempotent work or mask persistent failures. 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.