Devart Forums

Dear users,

Devart is glad to announce the release of dotConnect for PostgreSQL 7.10, Devart ADO.NET data provider for PostgreSQL with support for Entity Framework, LinqConnect (LINQ to PostgreSQL) and NHibernate. The new version offers you support for .NET Standard 2.0, .NET Core 2.0 and Entity Framework Core 2.0.

.NET Standard Compatible Assemblies

dotConnect provider for PostgreSQL now has .NET Standard compatible assemblies both for .NET Standard 1.3 and .NET Standard 2.0. .NET Standard 2.0 assemblies require .NET Core 2.0 or later or Full .NET Framework 4.6.1 or later. .NET Standard 2.0 compatible assemblies are not included in the product installers and are available only via NuGet packages, as well as .NET Standard 1.3 compatible assemblies.

NuGet packages of dotConnect for PostgreSQL now include both .NET Standard 1.3 and .NET Standard 2.0 compatible assemblies. The corresponding assemblies are selected automatically, depending on the target framework of your project.

Not all provider features, available for Full .NET Framework are also available in .NET Standard compatible assemblies. However, the new .NET Standard 2.0 compatible assemblies support much more features, that are not available in .NET Standard 1.3 compatible assemblies. Particularly, the new assemblies include support for distributed transactions, DataAdapter and CommandBuilder classes, Dump classes, etc. You can see the full list of features in the dotConnect for PostgreSQL documentation.

Technical Licensing

.NET Standard 2.0 compatible assemblies use the same licensing mechanism as .NET Standard 1.3 compatible assemblies. They use either license key files placed to a specific folder (C:\ProgramData\Devart\dotConnect\License\) or license keys provided as a connection string parameter. Note that trial license key files are generated by the trial installers of our product. If you want to try the .NET Standard compatible assemblies of our products, distributed via NuGet packages, you will still need to install the product in order to obtain the trial license key file. You can find more information about technical licensing in the dotConnect for PostgreSQL documentation.

New Features in Entity Developer

The new version of Entity Developer supports Entity Framework Core 2.0. Now you can design both Entity Framework Core 1.1 and 2.0 models. In Entity Framework Core 2.0 models you can use complex types for entity properties, Entity Framework Core 2.0 native mapping for database scalar functions, table splitting, generate self-contained type configuration code, etc.

Additionally, the new version of Entity Developer now supports executing LINQ queries against the model and retrieving data when working with projects, targeting .NET Core or .NET Standard.

PostgreSQL 10 Support

The new dotConnect for PostgreSQL version also supports PostgreSQL 10.


Here is the complete list of dotConnect for PostgreSQL 7.10.1013 features:

• .NET Standard 2.0 is supported
  • .NET Standard 2.0 compatible assemblies are added to the Devart.Data and Devart.Data.PgSql NuGet packages
  • Distributed transactions are supported
  • The PgSqlDataAdapter and PgSqlCommandBuilder are implemented
  • The PgSqlConnection.GetSchema() and PgSqlDataReader.GetSchemaTable() methods for metadata retrieving are implemented
  • The PgSqlDependency class is implemented
  • The PgSqlDataSourceEnumerator class is implemented
  • The PgSqlDump class is implemented
  • Dynamic columns creation in the PgSqlLoader class is implemented
  • Component classes in .NET Standard 2.0 compatible assemblies are inherited from the Component class, and some of them implement the ICloneable and ISupportInitialize interfaces
  • Some of the classes, representing data types, now implement the INullable and ISerializable interfaces
• .NET Core 2.0 is supported
• PostgreSQL 10 is supported
• The bug with a master-detail relation when a select command in the child table has a WHERE or ORDER BY clause is fixed

LinqConnect (formerly known as LINQ to PostgreSQL)

• .NET Standard 2.0 is supported
• .NET Core 2.0 is supported
• The macaddr8 data type introduced in PostgreSQL 10 is supported
• The bug with .Union().Any() is fixed

Entity Developer

• .NET Standard 2.0 projects in Visual Studio 2017 are supported
• .NET Core 2.0 projects in Visual Studio 2017 are supported
• Entity Framework Core 2.0 is supported
• The Retrieve Data functionality via Model Explorer for EF Core 2 is implemented
• The macaddr8 data type introduced in PostgreSQL 10 is supported
• The bug with escaping invalid XML characters in the comments generated by templates is fixed

Entity Framework support

• Entity Framework Core 1.1.3 is supported
• Entity Framework Core 2.0 is supported
• The macaddr8 data type introduced in PostgreSQL 10 is supported

Devart development team
http://www.devart.com/dotconnect/postgresql/