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]);
}
}
