PostgreSQL server

dotConnect for PostgreSQL supports PostgreSQL server since 8. version to 16, EnterpriseDB, Pervasive Postgres SQL servers, Heroku Postgres.

Framework Compatibility

The provider works with .NET Frameworks 2.0, 3.0, 3.5, 4.0, 4.5, 4.6, 4.7, or 4.8, .NET 5.0, NET 6.0, and .NET 7.0 , and .NET Compact Framework. dotConnect for PostgreSQL supports Mono version 2.0 and above. The product is compatible with ADO.NET Entity Framework v1 - v6 and Entity Framework Core 1.1.5, 2.2.6, 3.1.10, 5.0, 5.0. (PostgreSQL server 8.0 or higher is required for Entity Framework). The provider supports .NET Core 2.x, 3.x, and is compatible with EF Core 5, 6, 7, and 8.

Additionally, dotConnect for PostgreSQL provides .NET Standard 1.3 compatible assemblies, which are compatible with .NET Core 1.x and .NET Framework 4.6 and higher, and .NET Standard 2.0 compatible assemblies, compatible with .NET Core 2.0 and higher and .NET Framework 4.6.1 and higher. There are also .NET Standard 2.1 compatible assemblies for Entity Framework 6.3 and Entity Framework Core 3, 5, and 6, compatible with .NET Core 3.x and .NET 5.

IDE Compatibility

dotConnect for PostgreSQL can be used with following integrated development environments:

There are some limitations in Express Editions of Visual Studio. The following features are not available: provider add-in, automatic toolbox components registration and Server Explorer integration. As an exclusion, Visual Web Developer 2008 and 2010 supports Server Explorer features.

RAD Studio 2007 is supported in run time only as these environments have no WinForms designers.

Since dotConnect for PostgreSQL is available as NuGet packages, it supports Visual Studio Code. Visual Studio Code is a cross-platform code editor, developed by Microsoft.

Unlike Microsoft Visual Studio, Visual Studio Code does not support design-time features. Thus, there are no integration of dotConnect for PostgreSQL to Visual Studio Code, and no design-time features or wizards or other tools, etc.

Devart Data Providers Compatibility

Since Devart data providers use a common assembly (Devart.Data.dll), it is necessary to make sure that all installed data providers are compatible.