Support for Oracle 12c and Sync Framework in Devart .NET Connectivity Solutions
Devart software development company proudly announces the release of the new versions of dotConnect ADO.NET data providers, LinqConnect - LINQ to SQL compatible ORM solution, and Devart ORM designer - Entity Developer. New versions of dotConnect data providers offer developers Sync Framework support, support for Oracle 12c, improved PgSqlDump component, load balancing support in dotConnect for MySQL, and other features. Entity Developer and LinqConnect now support Oracle 12c.
Oracle 12c Support
dotConnect for Oracle and LinqConnect now support the latest Oracle version - Oracle 12c. Developers have an opportunity to use such new features of Oracle 12c as implicitly returned result sets, new connection modes (SYSBACKUP, SYSDG, SYSKM), autoincrement Identity columns, Transaction Guard, and more.
When working with Oracle 12c, the new Entity Developer 5.6 generates Identity columns instead of a sequence and a trigger for when generating a database script from a model with identity columns. Entity Developer also supports new Oracle 12c connection modes when creating a connection.
Sync Framework Support
dotConnect for Oracle, dotConnect for MySQL, dotConnect for PostgreSQL, dotConnect for SQLite, and dotConnect for DB2 now provide support for Sync Framework 2.1. The new versions of dotConnect ADO.NET providers include SyncProvider classes, classes for provisioning and deprovisioning, and SyncDescriptionBuilder classes for corresponding databases. Now users can easily synchronize their databases using Devart connectivity solutions.
Support for Load Balancing in MySQL
With the latest version of dotConnect for MySQL users can specify several hosts with their ports in the Host parameter of the connection string, and the data provider will switch host for each new SELECT or SHOW statement. The first host is considered the master server, and all statements, other than SELECT and SHOW, will be executed against it.
In the latest version of dotConnect for PostgreSQL the PgSqlDump component supports generating INSERT statements using the multirow VALUES syntax. Users may specify the max size of the generated INSERT statement. Besides, PgSqlDump now supports asynchronous backup and restore operations for more reliable development process.
SQLite Online Backup API Support
Previously dotConnect for SQLite offered the SQLiteDump component for backing up a SQLite database to a DDL/DML script. Now developers can use also SQLite Online Backup API for backing up a database with dotConnect for SQLite.
The new versions of dotConnect ADO.NET providers, LinqConnect, and Entity Developer are available for download and use for a free trial period of 30 days.
Please, find additional information about the updated products on the below specified pages:
Every Devart user, who wants to suggest a new feature for dotConnect data providers, LinqConnect, and Entity Developer, is invited to Devart forum at UserVoice
Here users may suggest their features or vote for already suggested ones.