Dotnet

Devart dotConnect for PostgreSQL v8.2.0 Professional

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

Description

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.

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.

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 12
Visual Studio support: 2008 – 2019
Platforms support:
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

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, and 3.1
NHibernate
LinqConnect

8.2.0 16-Nov-23

PostgreSQL 16 is supported
Visual Studio 2022 version 17.8 Preview is supported
The error during installation on the 32-bit version of Windows has been fixed
The bug with IPv6 host in the connection string is fixed
The bug with unhandled NullReferenceException is fixed

Entity Framework support

Entity Framework Core 7.0.5 is supported
Entity Framework Core 6.0.16 is supported
The bug with incorrect SQL translation of reused LINQ query, which includes array.Contains() and other expressions, in EF Core 5/6/7 is fixed
The bug with throwing Microsoft.EntityFrameworkCore.Infrastructure.ManyServiceProvidersCreatedWarning by the UsePostgreSql(DbConnection connection) extension method of DbContextOptionsBuilder in EF Core 6 and EF Core 7 is fixed
The bug with using custom converters in mapping in EF Core 3 and higher is fixed

Entity Developer

The bug with detecting the numeric default value of string columns as function-based column default value in EF Core Model is fixed

Additional Information