.NET Connector for PostgreSQL With ORM Support

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 priority support, frequent updates, and detailed documentation to help you with a quick and easy start.

Watch the video

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 allows connecting to PostgreSQL databases via TCP/IP with no need for native clients. This can greatly simplify application development and deployment.

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

Access 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

Learn more

The combination of speed and reliability

dotConnect for PostgreSQL facilitates .NET development with the quick fetching of background data. Performance can be fine-tuned with intelligent data management features like pagination and selective loading. Flexible error handling settings allow retrieving comprehensive information to troubleshoot and maintain data integrity.

Performance details

Compatibility and integration

Platforms

.NET 5.0, 6.0, 7.0, 8.0, 9.0
.NET Framework 2.0-4.8
.NET Core 1.x, 2.x, 3.0
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.

Features

Advanced connection configuration

Easily manage PostgreSQL connections with tools like PgSqlConnectionStringBuilder, enabling dynamic configuration of connection settings. Enable server discovery and metadata access to ensure flexible and reliable 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 advanced bulk import and backup tools. Use PgSqlLoader for high-performance loading of large datasets and PgSqlDump to easily create and restore database backups.

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.

Leading companies choose dotConnect

Other .NET connectors for databases

Ready to get started?

Get started with dotConnect for MySQL at no cost

Get started with dotConnect for PostgreSQL at no cost

Download a FREE, fully-functional trial version and elevate your database development and administration today!

Download for free

Try dotConnect Universal

Universal access to data of different databases for the Microsoft .NET Framework. It supports most of 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 any help or have questions about our tools or purchasing options, just get in touch with our team.

Contact support