ADO.NET provider for PostgreSQL with ORM support

DotConnect for PostgreSQL is a high-performance ORM data provider based on PostgreSQL. It provides a complete solution for developing PostgreSQL based database applications based on ADO.NET technology. It introduces new methods for designing application architecture, improves productivity, and promotes the development of database applications.

Our ADO.NET PostgreSQL provider supports various PostgreSQL specific features, such as secure SSL connections, PostgreSQL notifications, PostgreSQL batch data loading, GEOMETRY, PostgreSQL ARRAY types, and more.

Visual Studio Integration

DotConnect for PostgreSQL provides a large number of GUI tools that can improve productivity. For example, it includes Dataset tools such as the Dataset Wizard, Dataset Editor, and Dataset Manager, providing you with a convenient way to create and edit typed and untyped datasets.

The PostgreSQL ADO.NET provider supports advanced Visual Studio integration (DDEX) and provides a convenient visual component editor to simplify component tuning.

Wide compatibility

DotConnect for PostgreSQL is the first PostgreSQL database provider to support the. NET Core and Entity Framework Core, and we will strive to provide support for new platforms and development technologies as soon as they are released.

• PostgreSQL support: from 7.1 to 13
• Visual Studio Support: 2008-2019

Platform support:

• .NET 5.0
• Complete. NET Framework 2.0-4.8
• . NET Core 1. x, 2. x, and 3.0
• . NET Compact Framework 2.0 and higher
• Mono 2.0 and higher

Enhanced ORM support

DotConnect for PostgreSQL provides enhanced ORM support through the bundled ORM model visual designer - Entity Developer. Our PostgreSQL ADO.NET provider supports the following ORMs:

• Entity framework v1-v6
• Entity Framework Core 1. x, 2. x, 3.1, and 5.0
• NHibernate
• LinqConnect

features

• ASP.NET

Implement roles, session state, membership, configuration files, site maps, and other ASP 2.0 providers.

• performance

Use many PostgreSQL specific performance features and optimizations to ensure maximum performance.

• Bank for International Settlements

Enable Integration Services to export data to or import data from a PostgreSQL server.

• Monitoring method

Allow the use of free dbMonitor applications to track database events by component.

• security

Support various encrypted passwords, SSL and SSH connections, GSSAPI or SSPI, etc.