dotConnect for PostgreSQL

.NET Connector 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.

Features

ASP.NET

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

Performance

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

Monitoring

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

Security

Supports various encryption ciphers, SSL and SSH connections, etc.

Full list of features

Compatibility

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

Frameworks	Version support
Entity Framework Core	8, 7, 6, 5, 3, 2, 1
.NET	8, 7, 6, 5
.NET Core	3, 2, 1
.NET Framework	4.8, 4.7, 4.6, 4.5

More information here

Usage

To establish a connection to server you have to provide some connection parameters to dotConnect for PostgreSQL. This information is used by the PgSqlConnection component to find the server and login with credentials of your account. The parameters are represented as connection string. You can compose the connection string manually or have dotConnect for PostgreSQL construct it for you.

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

using Devart.Data.PostgreSql;
...
PgSqlConnection pgSqlConnection = new PgSqlConnection();
pgSqlConnection.Host = "db";
pgSqlConnection.Port = 5432;
pgSqlConnection.UserId = "postgres";
pgSqlConnection.Password = "postgres";

Read the full documentation for connection 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, and 8.0
NHibernate
Dapper

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.

License

See pricing options for ordering.

Trial Limitations

The dotConnect for PostgreSQL Evaluation License lets you try dotConnect for PostgreSQL Trial Edition for a period of 30 days. You may not use applications developed using Trial versions of the Software for any commercial purposes.

Devart Software