OraDirect .NET

by Devart (formerly Core Lab) - Product Type: Component / .NET Class / .NET Compact Framework / 100% Managed Code

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.

Our regular prices are shown below. Please logon to see your discounted prices.

OraDirect .NET V4.75 - Professional

Add to Cart	$ 195.95	1 Developer License - with 1 Year Subscription		Download (39.7 MB)
Add to Cart	$ 88.15	1 Developer License - Upgrade from V3.x Professional	Verify	Download (39.7 MB)
Add to Cart	$ 489.95	4 Developer Team License - with 1 Year Subscription		Download (39.7 MB)
Add to Cart	$ 1,175.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription		Download (39.7 MB)

OraDirect .NET V4.75 - Standard

Add to Cart	$ 146.95	1 Developer License - with 1 Year Subscription		Download (8.9 MB)
Add to Cart	$ 68.55	1 Developer License - Upgrade from V3.x Standard	Verify	Download (8.9 MB)
Add to Cart	$ 342.95	4 Developer Team License - with 1 Year Subscription		Download (8.9 MB)
Add to Cart	$ 979.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription		Download (8.9 MB)

OraDirect .NET V4.75 - Mobile

Add to Cart	$ 195.95	1 Developer License - with 1 Year Subscription		Download (6.0 MB)
Add to Cart	$ 88.15	1 Developer License - Upgrade from V3.x Mobile	Verify	Download (6.0 MB)
Add to Cart	$ 489.95	4 Developer Team License - with 1 Year Subscription		Download (6.0 MB)
Add to Cart	$ 1,175.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription		Download (6.0 MB)

OraDirect .NET Professional Subscription Renewals

Add to Cart	$ 78.35	1 Developer License Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 195.95	4 Developer Team License Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 489.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal	Verify	Download (29 KB)

OraDirect .NET Standard Subscription Renewals

Add to Cart	$ 58.75	1 Developer License Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 137.15	4 Developer Team License Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 391.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal	Verify	Download (29 KB)

OraDirect .NET Mobile Subscription Renewals

Add to Cart	$ 78.35	1 Developer License Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 195.95	4 Developer Team License Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 489.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal	Verify	Download (29 KB)

Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase. All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed above including volume licensing and previous versions.

Our regular prices are shown above. Please logon to see your discounted prices.

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

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)