ADO.NET 사용 시 소켓 연결 만들기
컬렉션을 사용해 정리하기
내 환경설정을 기준으로 콘텐츠를 저장하고 분류하세요.
ADO.NET 연결 객체를 사용하여 PostgreSQL용 Cloud SQL에 대한 Unix 소켓 연결을 엽니다.
더 살펴보기
이 코드 샘플이 포함된 자세한 문서는 다음을 참조하세요.
코드 샘플
C#
PostgreSQL용 Cloud SQL에 인증하려면 애플리케이션 기본 사용자 인증 정보를 설정합니다.
자세한 내용은 로컬 개발 환경의 인증 설정을 참조하세요.
달리 명시되지 않는 한 이 페이지의 콘텐츠에는 Creative Commons Attribution 4.0 라이선스에 따라 라이선스가 부여되며, 코드 샘플에는 Apache 2.0 라이선스에 따라 라이선스가 부여됩니다. 자세한 내용은 Google Developers 사이트 정책을 참조하세요. 자바는 Oracle 및/또는 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,["# 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)."]]