dotConnect for Oracle - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

dotConnect for Oracle by Devart (formerly Core Lab)

A 100% managed ADO.NET data provider for direct high performance access to Oracle servers for the .NET Framework. dotConnect for Oracle offers all Oracle data types support, including Oracle XML type, and Oracle object types OBJECT, VARRAY, TABLE, REF, provides extended functionality, ability of monitoring query and stored procedures execution, advanced design-time editors. dotConnect for Oracle supports Unicode, PL/SQL tables, connection pooling and array binding features, enables TAF support and working with Oracle homes and offers a lot of useful features.

dotConnect for Oracle is a data provider to direct access to Oracle database server for the Microsoft .NET Framework and .NET Compact Framework. It is completely based on ActiveX Data Objects for the .NET Framework (ADO.NET) technology. ADO.NET provides a rich set of components for creating distributed, data-sharing applications. It is an integral part of the .NET Framework, providing access to relational data, XML, and application data. dotConnect for Oracle data provider can be used in the same way as the SQL Server .NET or the OLE DB .NET Data Provider. dotConnect for Oracle can access Oracle server using Oracle Call Interface (OCI) or through TCP/IP directly.

OCI is low-level native application programming interface to access to Oracle database. Using OCI allows to create lightweight and fast applications working with Oracle. However, this way of communicating with Oracle server requires Oracle client software installed, which may be undesired or even impossible. For such cases dotConnect for Oracle provides an ability to use Direct mode. In Direct mode the provider connects without Oracle client and requires only TCP/IP protocol that allows to build really thin database applications.

dotConnect for Oracle provides functionality for connecting to Oracle database, executing commands, and retrieving results. Those results can be processed directly, or placed in an ADO.NET DataSet for further processing while in a 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 while in the DataSet can then be reconciled to Oracle database. dotConnect for Oracle data provider is designed to be lightweight. It consists of a minimal layer between Oracle database and your code. This extends functionality without sacrificing performance.

Here are some key features of dotConnect for Oracle Data Provider:

Direct mode to access without Oracle client

100% managed code

High performance

Supports Oracle 10g, 9i, 8i and 8.0

All Oracle data types support

Support Oracle object types OBJECT, VARRAY, TABLE, REF

Support Oracle XML type

Easy to deploy

.NET Compact Framework support

OracleScript component to execute scripts

OracleLoader component for fast loading data

OraclePackage component for easy working with PL/SQL packages

OracleDataTable component to retrieve and manipulate data from Oracle server data source

Metadata retrieval support

Ability of monitoring query and stored procedures execution by DBMonitor

Array binding feature

PL/SQL tables support

PL/SQL records support

Transparent Application Failover support

OS authentication enabled

DBA privileges to open a session with

Fill DataSet with several REF CURSOR

Fill DataSet with object, array and nested table data

Structural representation and editing of Oracle objects with OracleDataTable component

Advanced connection pooling

Paginal access to query result

Asynchronous execution support

Base-Class-Based provider model

Working with Oracle homes

Advanced design-time editors

Integrated OraDeveloper Tools for browsing database schema, manipulate database objects and visual building of queries

Wrapping PL/SQL packages with Package Wizard

Easy migration from MS OracleClient and ODP.NET with Migration Wizard

Help integrated into Visual Studio .NET

dotConnect for Oracle supports Oracle 10g, 9i, 8i and 8.0, including Personal and Lite editions. The provider works with .NET Framework 1.0, 1.1, 2.0, and can be used with the following development environments:

Microsoft Visual Studio .NET 2008

Microsoft Visual Studio .NET 2005

Microsoft Visual Studio .NET 2003

Borland Delphi 2005, Delphi 8

Borland C#Builder

dotConnect for Oracle can be used together with UniDirect .NET data provider that provides universal access to different databases within a single code.

Standard Features

.NET Framework support

ADO.NET core classes

Native data types classes and structures

OracleCommandBuilder class

OracleDataTable class

OracleScript class

OracleMonitor class

Design-time features, including component editors and property editors

Advanced Visual Studio .NET 2005 integration (Server Explorer and other features)

Migration Wizard

Professional Features (the Professional Edition includes all the features in the Standard Edition plus the following additional features)

OracleLoader class

OraclePackage class

Enterprise Library support

ASP.NET 2.0 providers support

Dataset Wizard

Package Wizard

OraDeveloper Tools

DBMonitor support

Mobile Features

.NET Compact Framework support

ADO.NET core classes

Native data types classes and structures

OracleCommandBuilder class

OracleDataTable class

OracleScript class

OracleMonitor class

Design-time features, including component editors and property editors

dotConnect for Oracle V5.0?

OraDirect .NET renamed to dotConnect for Oracle

Supported LINQ to Oracle

Added Entity Developer for LINQ to Oracle

What’s new in dotConnect for Oracle 4.7x?

Supported .NET Framework 3.5 Service Pack 1 Beta

Supported Visual Studio 2008 Service Pack 1 Beta

Improved support for ADO.NET Entity Framework

What’s new in dotConnect for Oracle 4.6x?

Supported Visual Studio designers for Entity Framework

Improved Entity Framework run time support

What’s new in dotConnect for Oracle 4.5x?

Oracle ANYDATA type supported

Added DB server-based data paging for web applications

OracleDataSource design time improvements

ASP.NET demo pack added

OracleSelectStatement.TryParse method added

OracleXml class changed

DataLink.DataSource property can refer to another DataLink component

What's new in dotConnect for Oracle V4.35x?

Visual Studio 2008 supported

Entity Framework Beta 3 supported

Added Licensing Information dialog

What's new in dotConnect for Oracle V4.25?

.NET Entity Framework Beta 2 supported

Visual Studio 2008 Beta 2 supported

Added Visual Basic versions to CRM, WinForms, and Web samples

Supported .NET Entity Framework

Supported Proxy Authentication

Supported OCI Pooling

Enhanced command builder with generation of row refresh statements

Added detailed warning information to OracleInfoMessageEventArgs class

Added DbCommand.GetRecordCount() method to determine rows count of a request

Added INullable interface for provider specific types

Improved LOBs performance in Direct mode

Added capability to store connection strings in application settings

Improved integration with OraDeveloper Tools

Extended drag'n'drop capabilities in DataSet Manager

Add-in menu moved to Visual Studio package

Demo projects reorganized

Added CRM (Customer Relationship Management) demo project

Added Ping demo project for Mobile Edition

What’s new in dotConnect for Oracle V4.0x?

Application development enhancement

Added DataSet Manager to control dataset instances in the project

Added DataSet Editor for convenient datasets manipulation

New OracleDataSet class to use with OracleDataTable

New component DataLink added for flexible data binding

New capabilities added to OracleDataTable class

Added capability for cross-form components cooperation

Design time visualization extended

Supported addin, DataSet Wizard, and OraDeveloper Tools integration with Borland Developer Studio

.NET 2 features

Added OracleDependency class to support Database Change Notification

Added OracleDataSourceEnumerator class to support Server Enumeration feature

Added support for Batch Update in OracleDataAdapter

Added support for returning provider-specific types in OracleDataReader and OracleDataAdapter

Advanced Oracle features

LOBs and Oracle Objects now entirely support the disconnected model

Supported Oracle Advanced Queue technology

New OracleAlerter component added

New OraclePipe component added

New OracleTrace component added

Oracle Client Software x64 supported

Added support for custom UDT classes

Added support for IN and IN/OUT REF CURSORs

OracleDataAdapter now supports sequential fetch

Added new class OracleGlobalization for managing culture settings

Whats new in dotConnect for Oracle V3.55.18?

Windows Vista support added

Whats new in dotConnect for Oracle V3.50.9?

Implemented advanced integration with Visual Studio 2005, including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder and configuring web component SqlDataSource

Mono support added

ASP.NET 2.0 providers added: Membership Provider, Role provider, Session State Provider, Profile provider (Professional edition only)

Capability to call dotConnect for Oracle runtime assemblies by partially trusted code added

Dataset Wizard added (Professional edition only)

Borland Delphi 2006 support added

Enterprise Library Data Access Application Block support added (Professional edition only)

Added streaming support for OracleScript

Added list of Frequently Asked Questions

OraDeveloper Tools installation separated from dotConnect for Oracle Professional installation

dotConnect for Oracle Professional is now compatible with version 1.70 of OraDeveloper Tools

Licensing for applications that call dotConnect for Oracle through DbProviderFactory added. This allows to use dotConnect for Oracle in SQL Server 2005 Business Intelligence Solutions

dotConnect for Oracle 3.0 offers you new features:

Access to Oracle server without Oracle client software with Direct mode

Support for .NET Compact Framework added with Mobile edition

OracleDataTable component greatly enhanced with OracleObject and Arrays advanced data binding and update capabilities

New functionality added to OracleScript component

Oracle warning support added to OracleConnection.InfoMessage event

Interface enhanced for OraclePackage component

Publisher policy file added for versions compatibility

Support for Microsoft Visual Studio 2005 Beta 2 added

A 100% managed ADO.NET data provider for direct high performance access to Oracle servers for the .NET Framework.

PartNumbers: PC-515950-176380 515950-176380 PC-515950-176386 515950-176386 PC-515950-176389 515950-176389 PC-515950-176385 515950-176385 PC-515950-178614 515950-178614 PC-515950-178615 515950-178615 PC-515950-178616 515950-178616 PC-515950-176381 515950-176381 PC-515950-176387 515950-176387 PC-515950-176390 515950-176390 PC-515950-176384 515950-176384 PC-515950-176382 515950-176382 PC-515950-176388 515950-176388 PC-515950-176391 515950-176391 PC-515950-176383 515950-176383 PC-515950-176392 515950-176392 PC-515950-176393 515950-176393 PC-515950-176394 515950-176394 PC-515950-178617 515950-178617 PC-515950-178618 515950-178618 PC-515950-178619 515950-178619 PC-515950-176395 515950-176395 PC-515950-176396 515950-176396 PC-515950-176397 515950-176397 PC-515950-176398 515950-176398 PC-515950-176399 515950-176399 PC-515950-176400 515950-176400

PurchaseOptions: dotConnect for Oracle V5.0 - Professional 1 Developer License - with 1 Year Subscription , dotConnect for Oracle V5.0 - Professional 1 Developer License - Upgrade from V3.x Professional , dotConnect for Oracle V5.0 - Professional 4 Developer Team License - with 1 Year Subscription , dotConnect for Oracle V5.0 - Professional 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription , dotConnect for Oracle V5.0 - Developer 1 Developer License - with 1 Year Subscription , dotConnect for Oracle V5.0 - Developer 4 Developer Team License - with 1 Year Subscription , dotConnect for Oracle V5.0 - Developer 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription , dotConnect for Oracle V5.0 - Standard 1 Developer License - with 1 Year Subscription , dotConnect for Oracle V5.0 - Standard 1 Developer License - Upgrade from V3.x Standard , dotConnect for Oracle V5.0 - Standard 4 Developer Team License - with 1 Year Subscription , dotConnect for Oracle V5.0 - Standard 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription , dotConnect for Oracle V5.0 - Mobile 1 Developer License - with 1 Year Subscription , dotConnect for Oracle V5.0 - Mobile 1 Developer License - Upgrade from V3.x Mobile , dotConnect for Oracle V5.0 - Mobile 4 Developer Team License - with 1 Year Subscription , dotConnect for Oracle V5.0 - Mobile 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription , dotConnect for Oracle Professional Subscription Renewals 1 Developer License Subscription Renewal , dotConnect for Oracle Professional Subscription Renewals 4 Developer Team License Subscription Renewal , dotConnect for Oracle Professional Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal , dotConnect for Oracle Developer Subscription Renewals 1 Developer License Subscription Renewal , dotConnect for Oracle Developer Subscription Renewals 4 Developer Team License Subscription Renewal , dotConnect for Oracle Developer Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal , dotConnect for Oracle Standard Subscription Renewals 1 Developer License Subscription Renewal , dotConnect for Oracle Standard Subscription Renewals 4 Developer Team License Subscription Renewal , dotConnect for Oracle Standard Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal , dotConnect for Oracle Mobile Subscription Renewals 1 Developer License Subscription Renewal , dotConnect for Oracle Mobile Subscription Renewals 4 Developer Team License Subscription Renewal , dotConnect for Oracle Mobile Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal

Resources: Read the dotConnect for Oracle License Agreement, Download the dotConnect for Oracle V5.0 evaluation on to your computer - Expires After 30 Days

Operating System for Deployment: Windows Vista, Windows XP, Windows Server 2003, Windows 2000

Architecture of Product: 32Bit

Product Type: Component

Component Type: .NET Class, .NET Compact Framework, 100% Managed Code

Compatible Containers: Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C# 2008, Microsoft Visual C# 2005, Delphi 2006 (10.0), Delphi 2005 (9.0), Delphi 8.0, Oracle Database 9i, Oracle Database 10g, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.0

Product Class: Business Components

Search Items: New Product Apr 05, New Product May 05, New Product July 05

Keywords: crlab corelab SQL query language Database DB Management Database DB Connectivity Author core lab, corelab, ora direct