Support for Oracle 12c and Sync Framework in Devart .NET Connectivity Solutions

Devart is glad to announce the release of the new versions of dotConnect ADO.NET data providers, LinqConnect ORM solution, and Devart ORM designer – Entity Developer.

Prague, Czech Republic, November 01, 2013 --( 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 hosts 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.

PgSqlDump Improvements

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.

Pricing and Availability

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.

The price for the latest version of dotConnect data providers starts from $99.95. The Single License for Entity Developer can be purchased for the price of $99.95. Users also can buy the Single License for LinqConnect for the price of as little as $149.95.

Please, find additional information about the updated products on the below specified pages:

dotConnect for Oracle 8.0
(Download -

dotConnect for MySQL 8.0
(Download -

dotConnect for PostgreSQL 7.0
(Download -

dotConnect for SQLite 5.0
(Download -

dotConnect for DB2 1.5
(Download -

LinqConnect 4.3
(Download -

Entity Developer 5.6
(Download -

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.

About Devart
Devart is a recognized vendor of database connectivity solutions for Microsoft .NET and Embarcadero Delphi development platforms as well as database development and management software.

Company's solutions support such databases as Microsoft SQL Server, Oracle, MySQL, PostgreSQL, InterBase, Firebird, and SQLite.

Along with database oriented software Devart offers productivity tools for Visual Studio which help developers to be empowered, stay focused, and deliver their best all the time.

For additional information about Devart, visit
Marina Nastenko