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)

URLs: dotconnect-for-oracle, dotconnect for oracle, dotconnectfororacle, devart

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 2010

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

What's new in dotConnect for Oracle V6.80?

Visual Studio 11 Beta support

What's new in dotConnect for Oracle V6.50?

Fluent Mapping support added

The bug inserting a TPT 'child' entity in case its primary key column names differ from the 'parent' entity ones is fixed

The bug deleting dependent entities when other changes were made is fixed

The bug entity materialization for queries with multiple eager loading options is fixed

The bug saving (inserting or updating) System.Data.Linq.Binary objects is fixed

The bug creating foreign keys in SQLite databases on DataContext.CreateDatabase is fixed

Support for enumerated types ("enums") in LinqConnect and Entity Framework June 2011 CTP models is implemented

New skins to improve the apllication appearance implemented

Selection driven highlighting implemented

Capability for changing the shape color for entities, complex types and enums mplemented

Capability for selecting the diagram skin type implemented

Changed behaviour: when the FirstLetterUpperCase / FirstLetterLowerCase option is enabled in Naming rules, each letter after underscore will be capital/lower

The bug saving custom attribute properties with default values in .edml files is fixed

The bug changing property names ("Index was outside the bounds of the array") is fixed

The bug incorrect generation of the private variables names in Entity Framework models is fixed

What's new in dotConnect for Oracle V6.30?

Oracle Workflow Instance Store implemented

Support for the Oracle TimesTen database implemented

DbTransactionBase class added

TransactionStateChanging and TransactionStateChanged events added to the DbConnectionBase class

Policy file for the Devart.Data.Oracle.Entity assembly added

The License Information Wizard improved: it now generates licenses for projects that have Entity Framework models or refer to Devart.Data.Oracle.Web, but have no direct references to Devart.Data.Oracle.dll

The "Use schema name" checkbox added to DataSet Wizard

Bug fix: Membership provider compatibility between .NET Framework 2.0 and 4.0

Bug fix: launching Devart documentation via Start menu

Bug fix: OracleTimeStamp.Parse() for time format with AM/PM

What's new in dotConnect for Oracle V6.10?

Added DDEX support in Express Edition

Fixed bug with resetting CopyLocal property of Devart references to False after using Upgrade Wizard

Fixed bug with unicode characters when using Upgrade Wizard

Fixed bug with compatibility with Microsoft Team Foundation Server 2010 Power Tools (broken designers for WPF, Silverlight, etc)

Fixed Visual Studio integration conflict with Windows Phone Developer Tools

LinqConnect (formerly known as LINQ to Oracle)

Fixed bug with deserializing LinqConnect exceptions

Fixed bug with attaching entities as modified to DataContext

Entity Developer

Added sorting in the 'Return Type' ComboBox for methods in the Properties window

Fixed code generation for many-to-many associations when the Unidirectional serialization mode is enabled (LinqConnect models)

Fixed bug with adding Oracle procedures declared inside packages to the model

Fixed some bugs in Table Per Concrete Type (TPC) design time support in Entity Framework models

Fixed bug with wrong Metadata Artifact Processing setting for Web Site projects in Entity Framework models

Entity Framework support

Microsoft Generate Database from Model Wizard: Changed Date type to Timestamp type for DateTime properties

What's new in dotConnect for Oracle V6.0?

Now returns error codes of SocketExceptions thrown on network errors occurring when opening direct connections

Implemented the OracleConnection.PassParametersByName property and the 'Pass Parameters By Name' connection string parameter

Added the 'Number Mappings' connection string parameter that allows to change default mappings of Oracle Number and Float types to .NET number types

Added the 'Validate Connection' connection string parameter to validate connections from pools.

Fixed bug setting XMLTYPE fields of Oracle Objects

Fixed bug creating timestamps with Timezone = 14

Fixed bug with WebSite projects in Delphi Prism

Fixed bug with DbType.String parameter for long strings (>4000)

What's new in dotConnect for Oracle V5.70.140?

Now Supports password salt in ASP.NET

Added ClientId connection parameter

Improved Upgrade wizard

Changed generation of overloaded procedures names in Oracle Package Wizard

Changed default behaviour of OracleTransaction without explicit Commit/Rollback call (RollBack now)

Fixed bug with Upgrade Wizard on web sites

Fixed bug with disposing data table with InterForm ParentRelation

Fixed bug with lost InterForm connection

Fixed bug with executing a PL/SQL block with two parameters of the same name

Fixed bug with using Oracle Client 8

Fixed memory leak on selecting result sets containing geometry type

Fixed bug with opened cursors on dequeuing in Direct mode

Fixed bug with fetching large amount of rows of geometry type

Fixed bug with errors in ora log file in Direct mode

Fixed bug with hashed passwords in Membership provider

What's new in dotConnect for Oracle V5.60.120?

Supports Visual Studio 2010

Install Wizard improved (ability to automatically uninstall previous version)

ADO.NET Data Services v1.5 supported

Added possibility to avoid connecting to dbMonitor.exe when using DbMonitor ancestors

Transaction rollback timeout changed from ConnectionTimeout to DefaultCommandTimeout

What's new in dotConnect for Oracle V5.35?

Integration with improved dbMonitor added

Implemented DefaultCommandTimeout parameter in connection string (by default, set to 0)

Added orderid column for Site Map provider for custom map node ordering

Added some DataSet Wizard design-time improvements

Changed default value of OracleCommand.CommandTimeout (set to 0)

Fixed bug with OracleCommandBuilder when column name coincides with key word

Fixed bug with MembershipProvider.GetAllUsers() method

Fixed bug with using OracleDataAdapter in Butch update mode

Fixed problem with consecutive usage of local and distributed transactions on the same connection with Oracle XE

Fixed bug with OracleDataReader.GetInt32(int) and GetInt64(int) methods

Fixed bug with DataLink.DataSource property after regeneration of DataSet

What's new in dotConnect for Oracle V5.x?

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.

Pricing: dotConnect for Oracle V6.80 - Professional 1 Developer License - with 1 Year Subscription, dotConnect for Oracle V6.80 - Professional 1 Developer License Upgrade from Standard - with 1 Year Subscription, dotConnect for Oracle V6.80 - Professional 1 Developer License Upgrade from Developer - with 1 Year Subscription, dotConnect for Oracle V6.80 - Professional 4 Developer Team License - with 1 Year Subscription, dotConnect for Oracle V6.80 - Professional 4 Developer Team License Upgrade from Standard - with 1 Year Subscription, dotConnect for Oracle V6.80 - Professional 4 Developer Team License Upgrade from Developer - with 1 Year Subscription, dotConnect for Oracle V6.80 - Professional 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, dotConnect for Oracle V6.80 - Professional 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from Standard - with 1 Year Subscription, dotConnect for Oracle V6.80 - Professional 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from Developer - with 1 Year Subscription, dotConnect for Oracle V6.80 - Developer 1 Developer License - with 1 Year Subscription, dotConnect for Oracle V6.80 - Developer 4 Developer Team License - with 1 Year Subscription, dotConnect for Oracle V6.80 - Developer 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, dotConnect for Oracle V6.80 - Standard 1 Developer License - with 1 Year Subscription, dotConnect for Oracle V6.80 - Standard 1 Developer License - Upgrade from V3.x Standard, dotConnect for Oracle V6.80 - Standard 1 Developer License - Upgrade from V3.x Standard - with 1 Year Subscription, dotConnect for Oracle V6.80 - Standard 4 Developer Team License - with 1 Year Subscription, dotConnect for Oracle V6.80 - Standard 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, dotConnect for Oracle V6.80 - Standard 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from V3.x Standard - with 1 Year Subscription, dotConnect for Oracle V6.80 - Mobile 1 Developer License - with 1 Year Subscription, dotConnect for Oracle V6.80 - Mobile 1 Developer License - Upgrade from V3.x Mobile - with 1 Year Subscription, dotConnect for Oracle V6.80 - Mobile 4 Developer Team License - with 1 Year Subscription, dotConnect for Oracle V6.80 - 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) Subscri

Evals & Downloads: Read the dotConnect for Oracle help file, Read the dotConnect for Oracle License Agreement, Download the dotConnect for Oracle V6.80 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: MS Visual Studio 11 Beta, Microsoft Visual Studio 2010, Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, MS Visual Basic 11 Beta, Microsoft Visual Basic 2010, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, MS Visual C++ 11 Beta, Microsoft Visual C++ 2010, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, MS Visual C# 11 Beta, Microsoft Visual C# 2010, 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, Oracle Database 11g, .NET Framework 4.5 Beta, .NET Framework 4.0, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.0

Product Class: Business Components

Keywords: core lab, corelab, ora direct

crlab corelab

Database DB Connectivity

Database DB Management

SQL query language

Part numbers: PC-515950-449325 515950-449325 PC-515950-449375 515950-449375 PC-515950-449381 515950-449381 PC-515950-449339 515950-449339 PC-515950-449377 515950-449377 PC-515950-449383 515950-449383 PC-515950-449335 515950-449335 PC-515950-449379 515950-449379 PC-515950-449385 515950-449385 PC-515950-449363 515950-449363 PC-515950-449365 515950-449365 PC-515950-449367 515950-449367 PC-515950-449327 515950-449327 PC-515950-449337 515950-449337 PC-515950-449387 515950-449387 PC-515950-449341 515950-449341 PC-515950-449333 515950-449333 PC-515950-449389 515950-449389 PC-515950-449329 515950-449329 PC-515950-449391 515950-449391 PC-515950-449343 515950-449343 PC-515950-449331 515950-449331 PC-515950-449345 515950-449345 PC-515950-449347 515950-449347 PC-515950-449349 515950-449349 PC-515950-449369 515950-449369 PC-515950-449371 515950-449371 PC-515950-449373 515950-449373 PC-515950-449351 515950-449351 PC-515950-449353 515950-449353 PC-515950-449355 515950-449355 PC-515950-449357 515950-449357 PC-515950-449359 515950-449359 PC-515950-449361 515950-449361