使用 ADO.NET 时设置连接时长

配置使用 ADO.NET Connection 对象连接到 Cloud SQL for MySQL 时连接可以持续保持的秒数上限。

深入探索

如需查看包含此代码示例的详细文档，请参阅以下内容：

• 管理数据库连接

代码示例

C#

如需向 Cloud SQL for MySQL 进行身份验证，请设置应用默认凭据。如需了解详情，请参阅为本地开发环境设置身份验证。

// ConnectionLifeTime sets the lifetime of a pooled connection
// (in seconds) that a connection lives before it is destroyed
// and recreated. Connections that are returned to the pool are
// destroyed if it's been more than the number of seconds
// specified by ConnectionLifeTime since the connection was
// created. The default value is zero (0) which means the
// connection always returns to pool.
connectionString.ConnectionLifeTime = 1800; // 30 minutes

后续步骤

如需搜索和过滤其他 Google Cloud 产品的代码示例，请参阅 Google Cloud 示例浏览器。