使用 ADO.NET 時實作指數輪詢
透過集合功能整理內容
你可以依據偏好儲存及分類內容。
使用 Polly .NET 程式庫,透過 ADO.NET 連線至 PostgreSQL 適用的 Cloud SQL 時,請使用指數輪詢重試失敗的連線。
深入探索
如需包含這個程式碼範例的詳細說明文件,請參閱下列內容:
程式碼範例
C#
如要向 PostgreSQL 適用的 Cloud SQL 進行驗證,請設定應用程式預設憑證。
詳情請參閱「為本機開發環境設定驗證」。
除非另有註明,否則本頁面中的內容是採用創用 CC 姓名標示 4.0 授權,程式碼範例則為阿帕契 2.0 授權。詳情請參閱《Google Developers 網站政策》。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\nRetry a failed connection by using exponential backoff when connecting to Cloud SQL for PostgreSQL by 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/postgres/manage-connections)\n\nCode sample\n-----------\n\n### C#\n\n\nTo authenticate to Cloud SQL for PostgreSQL, 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\u003cNpgsqlException\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_postgres)."]]