dotConnect Universal Publisher's description
dotConnect Universal offers universal access to data of different databases for the Microsoft .NET Framework.
dotConnect Universal offers universal access to data of different databases for the Microsoft .NET Framework. It supports most of major database servers, including Microsoft SQL Server, Microsoft Access, Oracle, DB2, MySQL, PostgreSQL, SQLite, InterBase, and Firebird. Other servers can be accessed through their ADO.NET, OLE DB and ODBC providers.
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.
dotConnect Universal doesn't implement database specific access layer for all databases, it uses native ADO.NET providers and depends on their functionality. The Professional Edition of dotConnect Universal includes bundled data providers for Oracle, MySQL and PostgreSQL (see diagram below). For all other servers you need a native data provider.
dotConnect Universal provides functionality for connecting to a database, executing commands, and retrieving results. These results can be processed directly or placed in an ADO.NET DataSet for further processing in disconnected state. While in the DataSet, data can be exposed to the user, combined with other data from multiple sources, or passed remotely between tiers. Any processing performed on the data in the DataSet can then be reconciled with the database.
The following diagram illustrates dotConnect Universal architecture. The green area represents some of dotConnect Universal components. The lime area unites bundled providers in the Professional Edition. The rest of the diagram objects represent data access elements inside and outside of the .NET Framework.
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
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
What's New in This Release:В· Compatible with other dotConnect providers
System Requirements:No special requirements.
Program Release Status: Minor Update
Program Install Support: Install Only