About dotConnect Universal

Provide access to major database servers from your .NET application.

dotConnect Universal offers universal access to data from different databases for the Microsoft .NET Framework. It supports most major database servers, including Microsoft SQL Server, Microsoft Access (Professional Edition only), Oracle, DB2, MySQL, PostgreSQL, InterBase, and Firebird. Other servers can be accessed through their ADO.NET, OLE DB and ODBC providers. The main feature of dotConnect Universal is an access to multiple database servers with 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 your IDE, which reduces development time.

Key features

  • 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 and PostgreSQL
  • 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 and Delphi

Editions

dotConnect Universal has two editions: Professional and Mobile. Professional edition includes additional classes, design-time extensions and wizards. Mobile edition is for .NET Compact Framework. Note that Professional edition is shipped with built-in data providers for Oracle, MySQL and PostgreSQL.

Mobile

  • .NET Compact Framework support
  • ADO.NET core classes
  • Native data types classes and structures
  • UniCommandBuilder class
  • UniScript class
  • UniMonitor class
  • Design-time features, including component editors and property editors

Professional

  • .NET Framework support
  • ADO.NET core classes
  • Native data types classes and structures
  • UniCommandBuilder class
  • UniScript class
  • UniMonitor class
  • Bundled data providers for Oracle, MySQL and PostgreSQL
  • Enterprise Library support
  • ASP.NET providers support
  • Design-time features, including component editors and property editors
  • Advanced Visual Studio .NET integration (Server Explorer and other features)
  • Dataset Wizard
  • Migration Wizard
  • DBMonitor support