使用 ADO.NET 时实现指数退避算法
使用集合让一切井井有条
根据您的偏好保存内容并对其进行分类。
演示使用 Polly .NET 库中的 ADO.NET 连接到 Cloud SQL for SQL Server 时如何实现指数退避避算法来重试失败的连接。
深入探索
如需查看包含此代码示例的详细文档,请参阅以下内容:
代码示例
C#
如需向 Cloud SQL for SQL Server 进行身份验证,请设置应用默认凭据。如需了解详情,请参阅为本地开发环境设置身份验证。
如未另行说明,那么本页面中的内容已根据知识共享署名 4.0 许可获得了许可,并且代码示例已根据 Apache 2.0 许可获得了许可。有关详情,请参阅 Google 开发者网站政策。Java 是 Oracle 和/或其关联公司的注册商标。
[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["很难理解","hardToUnderstand","thumb-down"],["信息或示例代码不正确","incorrectInformationOrSampleCode","thumb-down"],["没有我需要的信息/示例","missingTheInformationSamplesINeed","thumb-down"],["翻译问题","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],[],[],[],null,["# Implement exponential backoff when using ADO.NET\n\nDemonstrates how to implement exponential backoff to retry failed connections when connecting to Cloud SQL for SQL Server using ADO.NET with the Polly .NET library.\n\nExplore further\n---------------\n\n\nFor detailed documentation that includes this code sample, see the following:\n\n- [Manage database connections](/sql/docs/sqlserver/manage-connections)\n\nCode sample\n-----------\n\n### C#\n\n\nTo authenticate to Cloud SQL for SQL Server, set up Application Default Credentials.\nFor more information, see\n\n[Set up authentication for a local development environment](/docs/authentication/set-up-adc-local-dev-environment).\n\n Policy\n .Handle\u003cSqlException\u003e()\n .WaitAndRetry(new[]\n {\n TimeSpan.FromSeconds(1),\n TimeSpan.FromSeconds(2),\n TimeSpan.FromSeconds(5)\n })\n .Execute(() =\u003e connection.Open());\n\nWhat's next\n-----------\n\n\nTo search and filter code samples for other Google Cloud products, see the\n[Google Cloud sample browser](/docs/samples?product=cloud_sql_sqlserver)."]]