dotConnect Universal Portable 3.20.58

dotConnect Universal Portable 3.20.58 is considered as a smart as well as convenient to use program which 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.

Major Features:

1. Universal access to data of different databases
2. Supports all major databases
3. Supports most of the popular ADO.NET providers
4. 100% managed code
5. High performance
6. Bundled data providers for Oracle, MySQL, PostgreSQL, and SQLite
7. UniSQL for writing server-independent queries
8. Provider-specific types infrastructure
9. Fill DataSet with several CURSOR for Oracle Database
10. Asynchronous execution support
11. DataSet Wizard to leverage design-time setup
12. Generate DataSet Wizard
13. Support for Data Access Application Block in Enterprise Library
14. ASP.NET data providers: Membership provider, Role provider, Session State provider, Profile provider
15. Easy to deploy
16. Base-Class-Based provider model
17. .NET Compact Framework support
18. Advanced connection pooling
19. UniScript component to execute scripts
20. Ability to retrieve metadata information
21. Ability of monitoring query and stored procedures execution
22. Advanced design-time editors
23. Easy migration from SQL Server, OLE DB, ODBC and Oracle Data Providers with Migration Wizard
24. Help integrated into Visual Studio .NET and Borland Delphi
25. Free support for registered users during 1 year
26. Licensed per a developer without royalty fee

Enhancements:

• Compatible with other dotConnect providers

Requirements:

• .NET Framework Compatibility
• • The provider works with .NET Frameworks 2.0, 3.0, 3.5, 4.0, and .NET Compact Framework 2.0. Note that .NET Framework 1.0 and 1.1 is not supported.
• IDE Compatibility
• • Microsoft Visual Studio 2010
  • Microsoft Visual Studio 2008
  • Microsoft Visual Studio 2005
  • Embarcadero Delphi Prism
  • CodeGear RAD Studio 2007
• Database Server Compatibility
• • Oracle
  • • dotConnect Universal supports Oracle servers 11g, 10g, 9i, 8i, 8.0 and 7.3, including Personal and Express editions.
    • dotConnect Universal supports both x86 and x64 versions of the following Oracle clients: 11g, 10g, 9i, 8i and 8.0.
  • Microsoft SQL Server
  • • dotConnect Universal supports SQL Server 2008, 2005 (including Express editions), SQL Server 2000 and MSDE.
  • MySQL
  • • dotConnect Universal supports MySQL server versions 6.0, 5.4, 5.1, 5.0, 4.1, 4.0 and 3.23 including Embedded servers (starting with 4.1)
  • PostgreSQL
  • • dotConnect Universal supports PostgreSQL server since 7.1 version to 9.0, EnterpriseDB, Pervasive Postgres SQL servers.
  • SQLite
  • • dotConnect Universal supports SQLite engine version 3 and higher.
  • InterBase
  • • InterBase: versions 5.x and higher.
    • Firebird: versions 2.x, 1.x.
    • Yaffil
  • DB2
  • • DB2 servers and clients: 8.0 and higher.
  • Microsoft Access
  • • version 95, 97, 2000, 2003, and 2007.
  • Sybase Adaptive Server Enterprise
  • • Sybase Adaptive Server Enterprise servers and clients: 11.0 and higher.
  • Sybase Advantage Database Server
  • • Sybase Advantage Database Server servers: 8.0 and higher.
    • Client (Sybase Advantage ODBC driver): 8.0 and higher.