How do you handle connection resiliency and transient faults?

Implement retries with exponential backoff for transient errors.

Wrap DB calls with retry policies (e.g., Polly). Detect transient SqlException numbers and retry safely for idempotent operations.