OraDirect .NET - Summary

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

Summary

OraDirect .NET by Devart (formerly Core Lab)

A 100% managed ADO.NET data provider for direct high performance access to Oracle servers for the .NET Framework. OraDirect .NET 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. OraDirect .NET 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.

OraDirect .NET 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. OraDirect .NET data provider can be used in the same way as the SQL Server .NET or the OLE DB .NET Data Provider. OraDirect .NET 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 OraDirect .NET 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.

OraDirect .NET 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. OraDirect .NET 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 OraDirect .NET 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

OraDirect .NET 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

OraDirect .NET 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

What’s new in OraDirect .NET 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 OraDirect .NET 4.6x?

Supported Visual Studio designers for Entity Framework

Improved Entity Framework run time support

What’s new in OraDirect .NET 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 OraDirect .NET V4.35x?

Visual Studio 2008 supported

Entity Framework Beta 3 supported

Added Licensing Information dialog

What's new in OraDirect .NET 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 OraDirect .NET 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 OraDirect .NET V3.55.18?

Windows Vista support added

Whats new in OraDirect .NET 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 OraDirect .NET 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 OraDirect .NET Professional installation

OraDirect .NET Professional is now compatible with version 1.70 of OraDeveloper Tools

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

OraDirect .NET 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

PartNumbers: PC-515950-156624 515950-156624 PC-515950-156630 515950-156630 PC-515950-156633 515950-156633 PC-515950-156629 515950-156629 PC-515950-156625 515950-156625 PC-515950-156631 515950-156631 PC-515950-156634 515950-156634 PC-515950-156628 515950-156628 PC-515950-156626 515950-156626 PC-515950-156632 515950-156632 PC-515950-156635 515950-156635 PC-515950-156627 515950-156627 PC-515950-156636 515950-156636 PC-515950-156637 515950-156637 PC-515950-156638 515950-156638 PC-515950-156639 515950-156639 PC-515950-156640 515950-156640 PC-515950-156641 515950-156641 PC-515950-156642 515950-156642 PC-515950-156643 515950-156643 PC-515950-156644 515950-156644

PurchaseOptions: OraDirect .NET V4.7 - Professional 1 Developer License - with 1 Year Subscription , OraDirect .NET V4.7 - Professional 1 Developer License - Upgrade from V3.x Professional , OraDirect .NET V4.7 - Professional 4 Developer Team License - with 1 Year Subscription , OraDirect .NET V4.7 - Professional 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription , OraDirect .NET V4.7 - Standard 1 Developer License - with 1 Year Subscription , OraDirect .NET V4.7 - Standard 1 Developer License - Upgrade from V3.x Standard , OraDirect .NET V4.7 - Standard 4 Developer Team License - with 1 Year Subscription , OraDirect .NET V4.7 - Standard 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription , OraDirect .NET V4.7 - Mobile 1 Developer License - with 1 Year Subscription , OraDirect .NET V4.7 - Mobile 1 Developer License - Upgrade from V3.x Mobile , OraDirect .NET V4.7 - Mobile 4 Developer Team License - with 1 Year Subscription , OraDirect .NET V4.7 - Mobile 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription , OraDirect .NET Professional Subscription Renewals 1 Developer License Subscription Renewal , OraDirect .NET Professional Subscription Renewals 4 Developer Team License Subscription Renewal , OraDirect .NET Professional Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal , OraDirect .NET Standard Subscription Renewals 1 Developer License Subscription Renewal , OraDirect .NET Standard Subscription Renewals 4 Developer Team License Subscription Renewal , OraDirect .NET Standard Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal , OraDirect .NET Mobile Subscription Renewals 1 Developer License Subscription Renewal , OraDirect .NET Mobile Subscription Renewals 4 Developer Team License Subscription Renewal , OraDirect .NET Mobile Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal

Resources: Read the OraDirect .NET Data Provider License Agreement, Download the Oradirect .NET Data Provider V4.7 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 Studio .NET 2003, Microsoft Visual Studio .NET, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual Basic .NET 2003, Microsoft Visual Basic .NET, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C++ .NET 2003, Microsoft Visual C++ .NET, Microsoft Visual C# 2008, Microsoft Visual C# 2005, Microsoft Visual C# .NET 2003, Microsoft Visual C# .NET, 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, .NET Framework 1.1, .NET Framework 1.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