Devart is glad to announce the release of dotConnect for PostgreSQL 7.11, 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 Entity Framework Core 2.1.1 and connections via SSH protocol.
Entity Framework Core 2.1.1 Support
dotConnect provider for PostgreSQL now supports the most recent Entity Framework Core version – 2.1.1. You can use such new Entity Framework Core features as lazy loading, query types, parameterized constructors, System.Transactions support, value conversions, etc.
Entity Developer allows you to design models for Entity Framework Core 2.1.1 and supports all the new features. You may define classes as query types, add parameters for class properties to a parameterized constructor, configure lazy loading for entire model or for separate navigation properties visually.
SSH Support
The new dotConnect for PostgreSQL version allows you to create connections via secure SSH protocol.
Here is the complete list of dotConnect for PostgreSQL 7.11.1172 features:
- SSH connections are supported
- SSL is supported in .NET Standard 2.0 provider assemblies
- The PgSqlDependency class is supported in the .NET Standard 1.3 version of provider assemblies
- The Unknown value is added to the Severity enum
- The SeverityMessage property is added to the PgSqlException and PgSqlError classes for returning a severity message
- The following static properties ServerMessageSeverityError, ServerMessageSeverityFatal, ServerMessageSeverityPanic, ServerMessageSeverityWarning, ServerMessageSeverityNotice, ServerMessageSeverityDebug, ServerMessageSeverityInfo and ServerMessageSeverityLog are added to PgSqlLocalization
- Entity Framework Core 2.1 is supported
- Query type support is added: classes now have the Query Type property, and if it is set to true, this class is generated as a query type
- Lazy loading for Entity Framework Core 2.1 is supported:
- Model now has the Use Lazy-Loading Proxies property, which enables lazy loading on the model level
- Navigation properties now have the Lazy property, which enables lazy loading for a specific navigation property
- Properties now have the Constructor Parameter property, for configuring a parameterized constructor of the class
- The "Include Environment Variables" property, determining whether context configuration will be extended with environment variables when a connection string from the appsettings.json file is used, is added to the EF Core template
- The "Json File Base Path" property, specifying the base path for file-based providers when a connection string from the appsettings.json file is used, is added to the EF Core template
- Entity Framework Core 2.1.1 is supported
- The bug with delimiting statements with Batch Updates in EF Core 2 is fixed
- The bug with applying the updated provider behavior after changing connection string options in EF Core 2 is fixed
- The bug with generating incorrect SQL when using IndexOf expression in EF Core is fixed
Devart development team
http://www.devart.com/dotconnect/postgresql/