dotConnect for PostgreSQL has three sets of assemblies:

• for full .NET Framework
• .NET Standard 1.3 compatible assemblies (compatible with .NET Core 1.0 and higher and .NET Framework 4.6 and higher)
• .NET Standard 2.0 compatible assemblies (compatible with .NET Core 2.0 and higher and .NET Framework 4.6.1 and higher)

dotConnect for PostgreSQL also has .NET Standard 2.1 compatible assemblies for Entity Framework 6.4 and Entity Framework Core 5 support on .NET Core 3.0 and higher. .NET Standard compatible assemblies are only available as NuGet packages, except for the Entity Framework Core 2 related assembly, installed by the installer.

The dotConnect for PostgreSQL installer does not install .NET Standard compatible assemblies, except for the Entity Framework Core 2 related assembly. You can get them only by installing dotConnect for PostgreSQL NuGet packages to your project. For trial version of dotConnect for PostgreSQL you will still need to install the dotConnect for PostgreSQL installer in order to obtain the license key files.

The dotConnect for PostgreSQL NuGet packages include both .NET Standard 1.3 compatible and .NET Standard 2.0 compatible assemblies. The corresponding assemblies are automatically selected, depending on the platform your project targets, when you install NuGet packages to your projects.

Limitations

Since .NET Core is limited in comparison to full .NET Framework, dotConnect for PostgreSQL .NET Standard compatible assemblies offer less classes and features than the assemblies for full .NET Framework, and dotConnect for PostgreSQL does not support certain technologies for other .NET platforms that are supported for the full .NET Framework. .NET Standard 1.3 compatible assemblies are significantly more limited than .NET Standard 2.0 compatible assemblies.

Here is the list of features, not supported in .NET Standard assemblies:

• DataLink, ParentDataRelation, and related features are not available in .NET Standard compatible assemblies.
• DataSet Wizard, DataSet Editor, and DataSet Manager also are not available for projects, targeting other .NET platforms than full .NET Framework.
• Sync Framework support. There are no .NET Standard compatible Devart.Data.Synchronization.dll and Devart.Data.PostgreSql.Synchronization.dll assemblies.
• Workflow Foundation support.
• Asynchronous query execution.
• Enterprise Library support.

The following features are supported in .NET Standard 2.0 compatible assemblies, but are not supported in .NET Standard 1.3 compatible assemblies:

• Support of SSL and SSH connections is guaranteed only on Windows, on x86 and x64 Intel (AMD) architecture.
• Database object metadata. Since there are no DataTable class, there are no GetSchema method to retrieve the PostgreSQL metadata as a DataTable.
• Query column metadata. Since there are no DataTable class, there are no PgSqlDataReader.GetSchemaTable method to retrieve the PostgreSQL metadata as a DataTable. However, you can retrieve these metadata in other way. The PgSqlDataReader class implements the IDbColumnSchemaGenerator interface, and has the GetColumnSchema method that retrieves typed metadata about colums of the query.
• PgSqlDataSet, PgSqlDataTable, PgSqlCommandBuilder, PgSqlDataAdapter and related classes.
• PgSqlDump class.
• Component classes of the dotConnect for PostgreSQL in .NET Standard 1.3 compatible assemblies are no longer inherited from the System.ComponentModel.Component class, because this class is not present in .NET Core. However, they still implement the System.ComponentModel.IComponent interface, because there is such interface in .NET Core 1.0.
• Classes that implement the ICloneable interface in assemblies for Full .NET Framework don't implement this interface in .NET Standard 1.3 compatible assemblies, because there is no such interface in .NET Core 1.0. However, they still have their public Clone() methods.

Other Differences

• The Unicode connection string parameter is set to true by default for .NET Core. For Full .NET Framework it is set to false by default.

See Also

Compatibility