Criar uma conexão de soquete usando ADO.NET
Mantenha tudo organizado com as coleções
Salve e categorize o conteúdo com base nas suas preferências.
Abra uma conexão de soquete Unix no Cloud SQL para PostgreSQL usando um objeto Conexão ADO.NET.
Mais informações
Para ver a documentação detalhada que inclui este exemplo de código, consulte:
Exemplo de código
Exceto em caso de indicação contrária, o conteúdo desta página é licenciado de acordo com a Licença de atribuição 4.0 do Creative Commons, e as amostras de código são licenciadas de acordo com a Licença Apache 2.0. Para mais detalhes, consulte as políticas do site do Google Developers. Java é uma marca registrada da Oracle e/ou afiliadas.
[[["Fácil de entender","easyToUnderstand","thumb-up"],["Meu problema foi resolvido","solvedMyProblem","thumb-up"],["Outro","otherUp","thumb-up"]],[["Difícil de entender","hardToUnderstand","thumb-down"],["Informações incorretas ou exemplo de código","incorrectInformationOrSampleCode","thumb-down"],["Não contém as informações/amostras de que eu preciso","missingTheInformationSamplesINeed","thumb-down"],["Problema na tradução","translationIssue","thumb-down"],["Outro","otherDown","thumb-down"]],[],[],[],null,["# Create a socket connection when using ADO.NET\n\nOpen a Unix socket connection to Cloud SQL for PostgreSQL by using an ADO.NET Connection object.\n\nExplore further\n---------------\n\n\nFor detailed documentation that includes this code sample, see the following:\n\n- [Connect from App Engine flexible environment](/sql/docs/postgres/connect-app-engine-flexible)\n- [Connect from App Engine standard environment](/sql/docs/postgres/connect-app-engine-standard)\n- [Connect from Cloud Build](/sql/docs/postgres/connect-build)\n- [Connect from Cloud Run](/sql/docs/postgres/connect-run)\n- [Connect using the Cloud SQL Auth Proxy](/sql/docs/postgres/connect-auth-proxy)\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 using Npgsql;\n using System;\n\n namespace CloudSql\n {\n public class PostgreSqlUnix\n {\n public static NpgsqlConnectionStringBuilder NewPostgreSqlUnixSocketConnectionString()\n {\n // Equivalent connection string:\n // \"Server=\u003cINSTANCE_UNIX_SOCKET\u003e;Uid=\u003cDB_USER\u003e;Pwd=\u003cDB_PASS\u003e;Database=\u003cDB_NAME\u003e\"\n var connectionString = new NpgsqlConnectionStringBuilder()\n {\n // The Cloud SQL proxy provides encryption between the proxy and instance.\n SslMode = SslMode.Disable,\n\n // Note: Saving credentials in environment variables is convenient, but not\n // secure - consider a more secure solution such as\n // Cloud Secret Manager (https://cloud.google.com/secret-manager) to help\n // keep secrets safe.\n Host = Environment.GetEnvironmentVariable(\"INSTANCE_UNIX_SOCKET\"), // e.g. '/cloudsql/project:region:instance'\n Username = Environment.GetEnvironmentVariable(\"DB_USER\"), // e.g. 'my-db-user\n Password = Environment.GetEnvironmentVariable(\"DB_PASS\"), // e.g. 'my-db-password'\n Database = Environment.GetEnvironmentVariable(\"DB_NAME\"), // e.g. 'my-database'\n };\n connectionString.Pooling = true;\n // Specify additional properties here.\n return connectionString;\n }\n }\n }\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)."]]