您现在访问的是微软AZURE全球版技术文档网站,若需要访问由世纪互联运营的MICROSOFT AZURE中国区技术文档网站,请访问 https://docs.azure.cn.

用于 .NET 的 Azure Database for PostgreSQL 库Azure Database for PostgreSQL libraries for .NET

概述Overview

使用 Azure Database for PostgreSQL 中存储的数据和资源。Work with data and resources stored in Azure Database for PostgreSQL.

客户端 APIClient API

建议用于访问 Azure Database for PostgreSQL 的客户端库是开源 Npgsql ADO.NET 数据提供程序The recommended client library for accessing Azure Database for PostgreSQL is the open-source Npgsql ADO.NET data provider. 使用 ADO.NET 提供程序可以借助 Npgsql 的 Entity Framework 6Entity Framework Core 提供程序连接到数据库,并直接或通过 Entity Framework 执行 SQL 语句。Use the ADO.NET provider to connect to the database and execute SQL statements directly or through Entity Framework with the Npgsql's Entity Framework 6 or Entity Framework Core providers.

直接从 Visual Studio 包管理器控制台或使用 .NET Core CLI 安装 NuGet 包Install the NuGet package directly from the Visual Studio Package Manager console or with the .NET Core CLI.

Visual Studio 包管理器Visual Studio Package Manager

Install-Package Npgsql

.NET Core CLI.NET Core CLI

dotnet add package Npgsql

代码示例Code Example

/* Include this 'using' directive...
using Npgsql;
*/

// Always store connection strings securely. 
string connectionString = "Server=[servername].postgres.database.azure.com; " +
    "Port=5432; Database=myDataBase; User Id=[userid]@[servername]; Password=password;";

// Best practice is to scope the NpgsqlConnection to a "using" block
using (NpgsqlConnection conn = new NpgsqlConnection(connectionString))
{
    // Connect to the database
    conn.Open();

    // Read rows
    NpgsqlCommand selectCommand = new NpgsqlCommand("SELECT * FROM MyTable", conn);
    NpgsqlDataReader results = selectCommand.ExecuteReader();
    
    // Enumerate over the rows
    while(results.Read())
    {
        Console.WriteLine("Column 0: {0} Column 1: {1}", results[0], results[1]);
    }
}

示例Samples