dotConnect Universal provides universal access to different databases within the Microsoft.NET Framework. It supports all major databases, including Microsoft SQL Server and Microsoft Access. Access to other servers can be made through OLE DB, ADO.NET, and ODBC providers.
DotConnect Universal is based upon ADO.NET technology. It can be used in the same way as the SQL Server.NET data provider. Access to multiple databases servers from the same code is the main feature of dotConnect Universal. DotConnect Universal allows you to bypass the need to write conditional code for different providers or use ADO.NET interfaces directly. dotConnect Universal supports design-time development and integrates with IDE. This greatly reduces development time.
dotConnect Universal does not implement a database-specific access layer for all databases. Instead, it relies on native ADO.NET providers. DotConnect Universal Professional Edition includes data providers for Oracle and MySQL (see diagram below). You will need a native provider for all other servers.
DotConnect Universal allows you to connect to a database, execute commands and retrieve results. These results can either be processed immediately or stored in an ADO.NET DataSet to allow processing in a disconnected state. Data can be shared with the user while in the DataSet. It can also be combined with data from other sources or transmitted between tiers remotely. The DataSet allows for the reconciliation of any processing that has been done to the data.
This diagram shows dotConnect Universal architecture. Some components of dotConnect Universal are represented in the green area. The Professional Edition includes bundled providers. The remainder of the diagram objects represents data accessibility elements within and outside the.NET Framework.
Devart dotConnect Universal Professional Great Features:
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, a 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
The 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
Click on the below link to download Devart dotConnect Universal Professional with Patcher NOW!
Write your comment!
Access Permission Error
You do not have access to this product!
Dear User! To download this file(s) you need to purchase this product or subscribe to one of our VIP plans.