dotConnect Universal

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.

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, 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

dotConnect Universal - Features

Key Features New Features in Version 2.10

UniDirect .NET 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, InterBase, and Firebird. Other servers can be accessed through their ADO.NET, OLE DB and ODBC providers.

Key Features

The following list presents the main advantages of the UniDirect .NET.

• 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 .NET and Borland Delphi
• Free support for registered users during 1 year
• Licensed per a developer without royalty fee

New features in UniDirect .NET 2.10

• New assemblies for bundled providers
• Windows Vista support added
• .NET Framework 2.0 support added
• Visual Studio 2005 support added
• Added Professional edition with bundled data providers for Oracle, MySQL and PostgreSQL
• Support for .NET Compact Framework added
• ASP.NET 2.0 providers added: Membership Provider, Profile Provider, Role Provider, Session State Provider
• Implemented advanced integration with Visual Studio 2005, including Server Explorer, Data Source wizard, TableAdapter configuration
• Dataset Wizard added
• Enterprise Library Data Access Application Block support added
• The Base-Class-Based provider model used

Provider-specific types infrastructure

• UniDbType enumeration added
• UniBlob class added
• UniCursor class added
• UniDecimal class added

UniSQL (server-independent query language) features

• Conditional macro expressions as UniMacros class
• Universal support for literals and identifiers
• Universal quoting
• Conditional inclusion of SQL clauses
• Function mapping
• Unified OUTER JOIN syntax

Other features

• Borland Delphi 2006 support added
• Connection pooling functionality added
• Metadata schemas support added
• Bug with invalid parameter index fixed

dotConnect Universal - System Requirements

UniDirect .NET works with .NET Framework 1.1, 2.0, 3.0, 3.5, .NET Compact Framework 2.0, and can be used with the following development environments:

• Microsoft Visual Studio .NET 2005
• Microsoft Visual Studio .NET 2003
• Microsoft Visual Studio .NET 2002
• Delphi for .NET and RAD Studio 2007
• Turbo Delphi for .NET Professional
• Turbo C# Professional
• Borland Developer Studio 2006
• Borland Developer Studio 2005
• Borland Delphi 8
• Borland C#Builder

Prior to running Setup to install the UniDirect .NET, you must already have the .NET Framework 1.1 or 2.0 installed on the computer. If the .NET Framework is not installed, the Setup program for the provider will fail.