dotConnect for PostgreSQL

dotConnect for PostgreSQL is a versatile enterprise-grade connector that enables access to PostgreSQL data in .NET applications of all levels. It delivers advanced ORM support, broad compatibility with PostgreSQL versions and .NET platforms, and easy integration with multiple IDEs, including Visual Studio.

Moreover, this connector regularly undergoes security and performance tests to make sure it stays ahead of the competition at all times. Extra benefits include premium support, frequent updates, and detailed documentation to help you with a quick and easy start.

• Advanced ORM support: EF Core, Dapper, NHibernate, LinqConnect, and more
• Full compliance with ADO.NET standards
• Secure SSL/SSH connections, proxy servers, and HTTP tunneling
• Advanced encryption and data integrity
• Support for PostgreSQL notifications, bulk data loading, GEOMETRY, and more
• Comprehensive support for PostgreSQL-specific data types
• Integration with Visual Studio

Installation

1. Install the NuGet Package

Or download the Windows installer (.exe) from the official website.

2. Activate license

• Free Trial License: Evaluate the full capabilities of dotConnect for PostgreSQL in a non-commercial environment—ideal for development and testing. Start your free trial
• Commercial License: Deploy dotConnect for PostgreSQL in commercial applications and access full technical support with a valid license. Purchase a license

Usage

This snippet directly configures a PostgreSQL connection using a connection string.

```csharp=

using Devart.Data.PostgreSql;

class Program

{

static void Main()

{

string connectionString = "" +

"Host=127.0.0.1;" +

"Port=5432;" +

"User Id=TestUser;" +

"Password=TestPassword;" +

"Database=sakila;" +

"Schema=public;" +

"LicenseKey=**********";

using (PgSqlConnection connection = new PgSqlConnection(connectionString))

{

try

{

connection.Open();

Console.WriteLine("Connection to PostgreSQL successful!");

}

catch (Exception ex)

{

Console.WriteLine($"PostgreSQL Error: {ex.Message}");

}

}

}

}

```

Read the full documentation for connection here.

Compatibility

The following table show which version of this package to use with which version of frameworks.

Entity Framework Core | 10, 9, 8, 7, 6, 5, 3, 2, 1

.NET | 10, 9, 8, 7, 6, 5

.NET Core | 3.1, 2

.NET Framework | 4.8-2.0

More information here

Enhanced ORM Support

dotConnect for PostgreSQL offers enhanced ORM support with a bundled visual designer for ORM models - Entity Developer. Our PostgreSQL ADO.NET Provider supports the following ORMs:

• Entity Framework v1 - v6
• Entity Framework Core 1.x, 2.x, 3.x, 5.0, 6.0, 7.0, 8.0, 9.0, 10.0
• NHibernate 1.x-5.x
• Dapper 1.x, 2.x

Advanced Visual Studio Integration with PostgreSQL

dotConnect for PostgreSQL provides a vast number of GUI tools that increase your productivity. For example, it includes DataSet tools, such as DataSet Wizard, DataSet Editor, DataSet Manager, provide you an easy way to create and edit typed and untyped DataSets.

PostgreSQL ADO.NET Provider supports advanced Visual Studio integration (DDEX) and provides convenient visual component editors to simplify component tweaking.