Azure Database for PostgreSQL libraries for .NET

Overview

Work with data and resources stored in Azure Database for PostgreSQL.

Client API

The recommended client library for accessing Azure Database for PostgreSQL is the open-source Npgsql ADO.NET data provider. 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.

Install the NuGet package directly from the Visual Studio Package Manager console or with the .NET Core CLI.

Visual Studio Package Manager

Install-Package Npgsql

.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