Implement exponential backoff when using ADO.NET

Retry a failed connection by using exponential backoff when connecting to Cloud SQL for PostgreSQL by using ADO.NET with the Polly .NET library.

Explore further

For detailed documentation that includes this code sample, see the following:

• Manage database connections

Code sample

C#

To authenticate to Cloud SQL for PostgreSQL, set up Application Default Credentials. For more information, see Set up authentication for a local development environment.

Policy
    .Handle<NpgsqlException>()
    .WaitAndRetry(new[]
    {
        TimeSpan.FromSeconds(1),
        TimeSpan.FromSeconds(2),
        TimeSpan.FromSeconds(5)
    })
    .Execute(() => connection.Open());

What's next

To search and filter code samples for other Google Cloud products, see the Google Cloud sample browser.