This section of the documentation contains topics that help you design powerful, flexible applications with use of dotConnect for Oracle advanced features. The section describes how to employ best the components and technologies that constitute dotConnect for Oracle.
There are many database application development approaches, each with its own advantages and drawbacks. This topic describes some of database application design patterns applicable with dotConnect for Oracle and lists their tradeoffs to help you decide which one best suits your development needs.
dotConnect for Oracle is the most compatible with OracleClient ADO.NET provider, and it provides the easiest migration from OracleClient. Read this topic if you are migrating your project from it.
The OracleDataTable component is one of the most effective tools in the dotConnect for Oracle arsenal. It combines connection to server, command object and data storage in single component with really comprehensive capabilities. In addition, it can accomplish data access tasks in both connected and disconnected models. This topic describes how you can use some of the OracleDataTable features.
dotConnect for Oracle enhances SQL handling capabilities with usage of parameters in SQL queries. You can make execution of a query or stored procedure very flexible using several simple techniques. This article describes some basics you must be acquainted with when working with parameters in dotConnect for Oracle, as well as parameters synchronization and some nuances related to usage of stored procedures.
dotConnect for Oracle has extra components designed to simplify some tasks and support Oracle specific technologies. Particularly, OracleLoader serves to load external data into Oracle databases with use of Direct Path API, OracleAlerter and OraclePipe transfer messages and data between connections or client applications, and so on. dotConnect for Oracle includes set of classes designed to work with Oracle Advanced Queuing technology.
dotConnect for Oracle leverages managing DataSets in your applications with such tools as DataSet Wizard and DataSet Manager. The DataSet Wizard allows you to create and manage typed provider-specific datasets. The DataSet Manager displays the data sources in your project represented by OracleDataSet and OracleDataTable classes and allows you to create a user interface with data-bound controls by dragging items from the window onto forms in the project.
Describes dotConnect for Oracle features, specific for WinForms applications.
Describes dotConnect for Oracle features, specific for ASP.NET applications.
This topic describes how to use command editor for setting SQL commands to the different data access components, like OracleDataTable, OracleDataAdapter, or OracleDataSource.
dotConnect for Oracle has useful feature - GetSchema method. It allows you to read server schema information without writing queries and parsing the output. All information you may want to obtain is brought to you by single function in easy-to-process format.
dotConnect for Oracle supports asynchronous execution of methods that take most of time in database applications. These are opening a connection, transferring large blocks of data, and other operations alike.
dotConnect for Oracle can be used in conjunction with Microsoft Enterprise Library Data Access Application Block. This topic describes what is Enterprise Library, what part of it can be substituted with dotConnect for Oracle, and how to use the bundle in your applications.
This section describes SQL Server Integration Services support in dotConnect for Oracle.
This tutorial describes how to use dotConnect for Oracle to synchronize Oracle databases with Microsoft Sync Framework.
This section describes dotConnect for Oracle integration with Windows Workflow Foundation.
This section describes dotConnect for Oracle performance counters support.