Set the connection duration when using ADO.NET

Configure the maximum number of seconds a connection can persist when connecting to Cloud SQL for PostgreSQL by using the ADO.NET Connection object.

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.

// ConnectionIdleLifetime sets the time (in seconds) to wait before
// closing idle connections in the pool if the count of all
// connections exceeds MinPoolSize.
connectionString.ConnectionIdleLifetime = 300;

What's next

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