ADO.NET Provider for PostgreSQL with ORM Support

dotConnect for PostgreSQL is a high-performance ORM enabled data provider for PostgreSQL that builds on ADO.NET technology to present a complete solution for developing PostgreSQL-based database applications. It introduces new approaches for designing application architecture, boosts productivity, and facilitates the development of database applications.

Our ADO.NET PostgreSQL provider supports a wide range of PostgreSQL-specific features, such as secure SSL connections, PostgreSQL notifications, PostgreSQL bulk data loading, GEOMETRY, PostgreSQL ARRAY types, and others.

With 16 years of development history, dotConnect for PostgreSQL provides an ultimate pack of robust data connectivity features and already empowers thousands of data-related .NET apps.

Advanced Visual Studio Integration

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.

Advanced Visual Studio Integration

Broad Compatibility

dotConnect for PostgreSQL was the first PostgreSQL database provider to support .NET Core and Entity Framework Core, and we work hard to support new platforms and development technologies as soon as they are released.

  • PostgreSQL support: from 7.1 to 14
  • Visual Studio support: 2008 – 2019
  • Platforms support:
    • .NET 5.0, 6.0 compatibility
    • macOS 11 Arm64 (or "Apple Silicon" or "Apple M1") support
    • Windows 11 is supported
    • Visual Studio 2022 version 17.2 is supported.
    • Full .NET Framework 2.0 – 4.8
    • .NET Core 1.x, 2.x, and 3.0
    • .NET Compact Framework 2.0 and above
    • Mono 2.0 and above
Broad Compatibility

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:

Enhanced ORM Support

Other dotConnect Providers for Databases

dotConnect for DB2
DB2
dotConnect for MySQL
MySQL
dotConnect for Oracle
Oracle
dotConnect for SQLite
SQLite
dotConnect for SQL Server
SQL Server

dotConnect for PostgreSQL Provider Features

ASP.NET

ASP.NET

Implements Role, Session State, Membership, Profile, Site Map, and other ASP 2.0 providers.
Performance

Performance

Uses many PostgreSQL-specific performance features & optimizations to ensure the highest performance.
Monitoring

Monitoring

Allows per-component tracing of database events with a free dbMonitor application.
BIS

BIS

Enables Integration Services to export and import data to/from PostgreSQL servers.
Security

Security

Supports various encryption ciphers, SSL and SSH connections, etc.
More features
More ADO.NET providers
Related Articles

Related Products

dotConnect for SQLite

Fast, ORM-enabled, and feature-rich ADO.NET provider for SQLite with support for Entity Framework, NHibernate, and LinqConnect ORMs
Try now Pricing

LinqConnect

A fast, lightweight, and easy to use LINQ to SQL compatible ORM solution for SQL Server, Oracle, MySQL, PostgreSQL, and SQLite
Try now Pricing

dotConnect for Universal

An ADO.NET provider for universal access to data of different databases while using the same code with support for most of major database servers
Try now Pricing

What our customers say

More testimonials Your testimonials
The best product for developing data-related applications, and it provides a GUI Interface which is very user-friendly and can easily be implemented and fulfill your task in a better way.
Muhammad Hamza
student, Government College University Lahore
Thanks a lot for your fast support and many thanks to the Devart Team for this great software!
René Möller
Thesycon Systemsoftware & Consulting GmbH
Very satisfied with the Devart Entity Framework .NET provider btw. Works very nice!
Tim van Rooijen

Frequently Asked Questions

How to make database connection with PostgreSQL via C#?

You need to assign a valid connection string to pgSqlConnection1 beforehand, and then use the pgSqlConnection1.Open(); command to open a connection.

Can I use PostgreSQL with ADO.NET?

Yes - Devart dotConnect for PostgreSQL is a solution, that is built on ADO.NET technology.

What types of secure connection are supported?

Devart dotConnect for PostgreSQL support various encryptions, SSL and SSH connections, and more.

We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.