Devart has released the new versions of dotConnect ADO.NET providers with support for Database-First approach in Entity Framework Core via Package Manager Console, support for JSON functionality of Oracle, MySQL, and PostgreSQL in Entity Framework, Oracle Advanced Security support in the Direct mode, and other features.


Devart, a recognized vendor of professional database management software for developers and DBAs, has released the new versions of dotConnect for Oracle, dotConnect for MySQL, dotConnect for PostgreSQL, and dotConnect for SQLite that now feature such useful functionality as support for Database-First approach in Entity Framework Core via Package Manager Console, support for JSON functionality of Oracle, MySQL, and PostgreSQL in Entity Framework, Oracle Advanced Security support in the Direct mode, and other features.


Devart dotConnect providers include the following new features and improvements now:


Entity Framework Core Database-First Support

Entity Framework Core supports the Database-First approach via the Scaffold-DbContext command of Package Manager Console. This command scaffolds a DbContext and entity type classes for a specified database. Now dotConnect providers with Entity Framework Core support also support this command that provides a way to quickly generate context and entity classes for an existing schema.

JSON Functionality Support in Entity Framework

Updated versions of dotConnect for Oracle, dotConnect for MySQL, and dotConnect for PostgreSQL now support the JSON functionality of the corresponding databases in Entity Framework v4 – v6. New provider versions allow using JSON-specific functions in LINQ to Entities queries.

Oracle Advanced Security Support in the Direct Mode

The latest version of dotConnect for Oracle supports Oracle Advanced Security Data Encryption and Oracle Advanced Security Data Integrity in the Direct mode. This feature allows connecting to Oracle Data Cloud in the Direct mode without the need of Oracle Client software

Other Improvements

Besides, all ADO.NET providers can now be installed without adding their assemblies to the GAC automatically. For the providers that support Entity Framework, Batch Updates support in Entity Framework Core also have been added to improve the performance.

For more information about dotConnect ADO.NET providers, please visit https://www.devart.com/dotconnect/


About Devart

Devart is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration and backup solutions. The company also implements Web and Mobile development projects.
For additional information about Devart, visit https://www.devart.com/.