dotConnect for PostgreSQL

.NET 10 available

PM> Install-Package Devart.Data.PostgreSql

Supported Platforms

.NET Connector for PostgreSQL With ORM Support

dotConnect for PostgreSQL is an enterprise-grade connector for secure and reliable access to PostgreSQL data in .NET applications. It offers broad compatibility with PostgreSQL versions and .NET platforms, integration with multiple IDEs, including Visual Studio, and advanced ORM support.

With Entity Developer, it can automatically generate entity classes and DbContext for Entity Framework Core, Entity Framework, NHibernate, and other supported ORMs, which helps reduce manual coding and speed up development.

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

Easy connection to PostgreSQL

dotConnect for PostgreSQL lets you connect to PostgreSQL databases via TCP/IP without native client libraries. This helps simplify application development, deployment, and maintenance.

C# Copy code

using Devart.Data.PostgreSql;

class Program
{
  static void Main()
  {
    using PgSqlConnection conn = new(
      "Host=localhost;" +
      "Port=5432;" +
      "Database=your_database;" +
      "User Id=your_username;" +
      "Password=your_password;" +
      "License Key=your_license_key;");
    conn.Open();
  }
}

Quick connection without any client libraries
Full support for PostgreSQL-specific data types
Robust security features with advanced encryption and authentication
Flexible connectivity options for diverse operational environments
Cost-effective deployment

Connect to the following databases:

PostgreSQL
Azure Database for PostgreSQL
AlloyDB
Amazon RDS for PostgreSQL

Amazon Aurora
Heroku Postgres
Google Cloud SQL for PostgreSQL

Connection details

Advanced ORM support

dotConnect for PostgreSQL offers enhanced ORM support when bundled with Entity Developer - a visual designer for ORM models:

Entity Framework Core

1.x, 2.x, 3.x, 5.0, 6.0, 7.0, 8.0, 9.0

NHibernate

1.x-5.x

Entity Framework

v1-v6

Dapper

1.x, 2.x

Explore the features

Speed and reliability

dotConnect for PostgreSQL supports fast and reliable .NET development with efficient data retrieval. You can fine-tune performance by using intelligent data management features such as pagination and selective loading. Flexible error-handling settings provide detailed diagnostic information to help troubleshoot issues and maintain data integrity.

Performance details

Compatibility and integration

Platforms

.NET 5.0, 6.0, 7.0, 8.0, 9.0, 10.0
.NET Framework 2.0-4.8
.NET Core 2.0-3.1
ASP.NET Core Blazor
.NET MAUI

PostgreSQL

All versions

Visual Studio Extension

Data source connection
Database object explorer
Data retrieval and display

Compatibility with NuGet

Works in any NuGet-compatible IDE like VS Code, JetBrains Rider, etc.

Compatibility details

Features

Advanced connection configuration

Manage PostgreSQL connections with tools like PgSqlConnectionStringBuilder, which lets you configure connection settings dynamically. Server discovery and metadata access provide more flexibility when you work with database connections.

Advanced data type support

Work natively with complex PostgreSQL types like ranges, arrays, composite types, and large objects. dotConnect provides .NET-friendly mappings for these advanced types, reducing manual serialization and improving type safety.

Bulk data operations and backups

Speed up data migration and maintenance with bulk import and backup tools. Use PgSqlLoader for high-performance loading of large datasets and PgSqlDump to create and restore database backups with ease.

Secure connectivity
and configuration

Protect data and connections with built-in support for SSH tunneling, SSL encryption, and secure storage of credentials. These features provide robust authentication and enhanced data security for applications in cloud and on-premise environments.

Event-driven monitoring
and change tracking

Implement responsive applications with real-time diagnostics and event notifications. PgSqlDependency and PgSqlMonitor allow you to track database changes, monitor SQL execution, and build event-driven solutions that instantly react to data updates.

Development wizards
in Visual Studio

Boost your productivity with PostgreSQL-specific Visual Studio wizards that simplify connection setup, dataset creation, and database migrations. They help reduce manual work and make common development tasks faster and easier.

View all features

Leading companies choose dotConnect

Explore other .NET connectors for databases

Your universal ADO.NET provider for multiple database systems

dotConnect Universal

dotConnect Universal offers universal access to data of different databases for the Microsoft .NET Framework. It supports the most popular database servers, including Microsoft SQL Server, Microsoft Access, Oracle Database, DB2, MySQL, PostgreSQL, SQLite, InterBase, and Firebird. Other servers can be accessed through their ADO.NET, OLE DB and ODBC providers.

$269.95

Developer edition

Buy now

Connect to PostgreSQL in .NET Applications

Learn how to connect a .NET application to PostgreSQL with dotConnect, set up secure SSL/TLS connections, use EF Core for LINQ queries, and generate code with Scaffold-DbContext.

Using Entity Framework Core With PostgreSQL

Explore how to use EF Core with PostgreSQL, from initial setup to advanced data operations. The article explains how PostgreSQL integration works with EF Core in practical scenarios.

PostgreSQL Connection Strings

Build a connection string for your .NET application to connect to PostgreSQL with dotConnect for PostgreSQL. This guide covers the essential parameters and advanced options.

Get started with dotConnect for PostgreSQL at no cost

Download a free fully functional trial and explore advanced tools for PostgreSQL development and administration.

Download for free

Try dotConnect Universal

Universal access to data from different databases for Microsoft .NET Framework. It supports most major database servers, including Microsoft SQL Server, Microsoft Access, Oracle, DB2, MySQL, PostgreSQL, SQLite, InterBase, and Firebird.

Get now

Need a hand?

If you need help or have questions about our tools or purchasing options, just get in touch with our team.

Contact support

Try the 30-day trial of the full product. No limits. No card required. Start free trial

.NET Connector for PostgreSQL With ORM Support