dotConnect Universal

dotConnect Universal is available as:

• Professional Edition

• Mobile Standard Edition

Note that Professional Edition is shipped with built-in data providers for Oracle, MySQL, PostgreSQL, and SQLite.

dotConnect Universal is based on ADO.NET technology and can be used in the same way as the SQL Server .NET Data Provider. The main feature of dotConnect Universal is an access to multiple database servers at the same code. With dotConnect Universal it is possible to avoid writing conditional code for different providers or using ADO.NET interfaces directly. dotConnect Universal implements full support of design-time development and integration with IDE, which allows to reduce development time greatly.

The following list presents the main advantages of the dotConnect Universal.

• Universal access to data of different databases

• Supports all major databases

• Supports most of the popular ADO.NET providers

• 100% managed code

• High performance

• Bundled data providers for Oracle, MySQL, PostgreSQL, and SQLite

• UniSQL for writing server-independent queries

• Provider-specific types infrastructure

• Fill DataSet with several CURSOR for Oracle Database

• Asynchronous execution support

• DataSet Wizard to leverage design-time setup

• Generate DataSet Wizard

• Support for Data Access Application Block in Enterprise Library

• ASP.NET data providers: Membership provider, Role provider, Session State provider, Profile provider

• Easy to deploy

• Base-Class-Based provider model

• .NET Compact Framework support

• Advanced connection pooling

• UniScript component to execute scripts

• Ability to retrieve metadata information

• Ability of monitoring query and stored procedures execution

• Advanced design-time editors

• Easy migration from SQL Server, OLE DB, ODBC and Oracle Data Providers with Migration Wizard

• Help integrated into Visual Studio .NET and Borland Delphi

• Free support for registered users during 1 year

• Licensed per a developer without royalty fee

1) Mobile Edition of dotConnect Universal can work only with the following servers: Oracle, SQL Server, MySQL, PostgreSQL