.NET Connector for PostgreSQL with ORM Support

dotConnect for PostgreSQL is a high-performance ADO.NET data provider that grants simple access to PostgreSQL databases when developing PostgreSQL-based applications.

It fully supports Entity Framework (EF Core), Dapper, and NHibernate, along with a wide range of PostgreSQL-specific features, such as secure SSL connections, PostgreSQL notifications, PostgreSQL bulk data loading, GEOMETRY, PostgreSQL ARRAY types, and others.

  • Broad compatibility with .NET platforms, including ASP.NET Core, Blazor, MAUI, .NET Framework, etc
  • Easy access to PostgreSQL without requiring specific client libraries
  • ORM support with Entity Framework (EF Core), Dapper, etc.
  • Full compliance with ADO.NET
  • SSL, SSH, proxy servers, and HTTP tunnels support
  • Regular updates and detailed documentation
  • Expert developer support

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

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, and 8.0

NHibernate

1.x-5.x

Entity Framework

V1-v6

Dapper

1.x, 2.x

Broad Compatibility

dotConnect for PostgreSQL is the only PostgreSQL data provider that supports modern platforms and technologies like .NET Core and Entity Framework Core, as well as multiple deprecated technologies, reducing support costs for existing applications.

Platforms
  • .NET 5, 6, 7, 8
  • .NET Framework 2.0-4.8
  • .NET Core 1.x, 2.x, and 3.0
  • ASP.NET Core Blazor
  • .NET MAUI
PostgreSQL

All versions

Microsoft Visual Studio

Visual Studio 2008-2022

Features

Database-Specific Features

Database-Specific Features

dotConnect for PostgreSQL effectively supports secure SSL connections, bulk data loading, PostgreSQL notifications, GEOMETRY, ARRAY types, and other PostgreSQL-specific features.

Advanced Durability

Advanced Durability

dotConnect for PostgreSQL delivers data fetching control (background, on-demand, pagination) and server-side data relationships. Additionally, selective column loading and refresh operations help maintain performance at an all-time high.

Microsoft Technology Support

Microsoft Technology Support

Our connector is seamlessly compatible with Microsoft's data-related technologies, such as Microsoft Enterprise Library, a variety of ASP.NET providers, ExtendedMembership providers, and Microsoft Sync Framework.

Secure Connection

Secure Connection

Without a doubt, the safety of connections is a top priority. That's why dotConnect for PostgreSQL provides support for encryption protocols, including SSL and SSH, and allows using HTTPS tunneling.

Fast Data Loading

Fast Data Loading

The PostgreSqlLoader component helps load large datasets into PostgreSQL databases with speed and precision. This leads to faster initialization and data population, as well as helps achieve remarkable performance during data-intensive operations

Advanced Visual Studio Integration

Integration With Visual Studio

dotConnect for PostgreSQL can be perfectly integrated with Microsoft Visual Studio, enhancing the design-time experience with Server Explorer connections and convenient dataset management tools.

View all features

Leading companies choose dotConnect

Wells fargo
Thermo fisher
Cisco
Xerox
Northrop grumman
Pfizer
Steel Dynamics, Inc.
FedEx
XPO Logistics, Inc.

Other .NET Connectors for Databases

Universal ADO.NET provider for different databases
dotConnect Universal
dotConnect Universal offers 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. Other servers can be accessed through their ADO.NET, OLE DB and ODBC providers.
$219.95
Professional edition
$319.95
Mobile Standard edition

More articles

Read More Articles

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!

Try dotConnect Universal

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

Need a hand?

Need a hand?

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