What is connection resiliency and transient retries in Entity Framework Core?

EF Core providers can support retrying transient connection or command failures through execution strategies. 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.