Core ADO.NET classes
dotConnect Universal uses a number of standard ADO.NET classes. Here is the list of those classes and brief descriptions of what they do:
- UniConnection - Establishes a connection to a database server and initiates a transaction.
- UniCommand - Executes SQL statements and stored procedures in a database and exposes parameters.
- UniDataReader - Provides access to and reads a forward-only stream of data from a database.
- UniDataAdapter - Populates a DataSet and synchronizes updates with a database.
- UniParameter - Defines input, output, and return value parameters for commands and stored procedures.
- UniException - Returned when a database error occurs.
- UniTransaction - Manages database transactions.
Extra ADO.NET classes
In addition to the core classes, a few extra ones have been implemented that extend the functionality of dotConnect Universal:
- UniConnectionStringBuilder - Constructs a connection string by assigning values to appropriate properties.
- UniMonitor - Tracks dynamic SQL execution in applications that use dotConnect Universal.
- UniProvider - Represents a custom ADO.NET data provider that can be used with dotConnect Universal.
- UniScript - Executes a series of SQL statements separated by special symbols.
- UniCommandBuilder - Automatically generates command properties for UniDataAdapter and populates the UniParameter collection of UniCommand objects.
Access to multiple databases with the same code
Since dotConnect Universal provides access to multiple database servers with the same code, it eliminates the need for writing conditional code for different providers or using ADO.NET interfaces directly.
- Easy connection without additional сlients.*
- *Please note that to get started, you will need third-party clients/drivers for SQL Server, Db2, Microsoft Access, InterBase, and Firebird.
- Support for native ADO.NET providers.
- Robust security with advanced encryption and authentication features.
- Flexible connectivity options for diverse operational environments.
- Cost-effective deployment.
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
- Common ADO.NET classes
- Native data types classes and structures
- UniCommandBuilder class
- UniScript class
- UniMonitor class
- Bundled data providers for Oracle, MySQL, PostgreSQL, and SQLite
- Design-time features, including component editors and property editors
Professional
- .NET Framework support
- Common ADO.NET classes
- Native data types classes and structures
- UniCommandBuilder class
- UniScript class
- UniMonitor class
- Bundled data providers for Oracle, MySQL, PostgreSQL, and SQLite
- Enterprise Library support
- ASP.NET providers support
- Design-time features, including component editors and property editors
- Advanced Visual Studio 2008 - 2022 integration (Server Explorer and other features)
- Dataset Wizard
- Migration Wizard
- dbMonitor support
