Screenshot Preview

dotConnect for Oracle

by Devart - 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. 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.

From
$ 235.16

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

Showing: All Prices | Renewals Only  in

dotConnect for Oracle V8.3.146 - Professional

Add to Cart $ 235.16 1 Developer License - with 1 Year Subscription Delivered via Download

Special Offer Price - Expires August 31st, 2014.

Add to Cart $ 117.56 1 Developer License Upgrade from Standard - with 1 Year Subscription Delivered via Download

Special Offer Price - Expires August 31st, 2014.

Add to Cart $ 39.16 1 Developer License Upgrade from Developer - with 1 Year Subscription Delivered via Download

Special Offer Price - Expires August 31st, 2014.

Add to Cart $ 548.76 4 Developer Team License - with 1 Year Subscription Delivered via Download

Special Offer Price - Expires August 31st, 2014.

Add to Cart $ 274.36 4 Developer Team License Upgrade from Standard - with 1 Year Subscription Delivered via Download

Special Offer Price - Expires August 31st, 2014.

Add to Cart $ 117.56 4 Developer Team License Upgrade from Developer - with 1 Year Subscription Delivered via Download

Special Offer Price - Expires August 31st, 2014.

Add to Cart $ 1,411.16 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription Delivered via Download

Special Offer Price - Expires August 31st, 2014.

Add to Cart $ 627.16 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from Standard - with 1 Year Subscription Delivered via Download

Special Offer Price - Expires August 31st, 2014.

Add to Cart $ 235.16 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from Developer - with 1 Year Subscription Delivered via Download

Special Offer Price - Expires August 31st, 2014.

dotConnect for Oracle V8.3.146 - Developer

Add to Cart $ 274.36 1 Developer License - with 1 Year Subscription Delivered via Download

Special Offer Price - Expires August 31st, 2014.

Add to Cart $ 666.36 4 Developer Team License - with 1 Year Subscription Delivered via Download

Special Offer Price - Expires August 31st, 2014.

Add to Cart $ 1,567.96 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription Delivered via Download

Special Offer Price - Expires August 31st, 2014.

dotConnect for Oracle V8.3.146 - Standard

Add to Cart $ 117.56 1 Developer License - with 1 Year Subscription Delivered via Download

Special Offer Price - Expires August 31st, 2014.

Add to Cart $ 274.36 4 Developer Team License - with 1 Year Subscription Delivered via Download

Special Offer Price - Expires August 31st, 2014.

Add to Cart $ 783.96 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription Delivered via Download

Special Offer Price - Expires August 31st, 2014.

dotConnect for Oracle V8.3.146 - Mobile

Add to Cart $ 156.76 1 Developer License - with 1 Year Subscription Delivered via Download

Special Offer Price - Expires August 31st, 2014.

Add to Cart $ 391.96 4 Developer Team License - with 1 Year Subscription Delivered via Download

Special Offer Price - Expires August 31st, 2014.

Add to Cart $ 940.76 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription Delivered via Download

Special Offer Price - Expires August 31st, 2014.

dotConnect for Oracle Professional Subscription Renewals

Add to Cart $ 146.95 1 Developer License Subscription Renewal Delivered via Email
Add to Cart $ 342.95 4 Developer Team License Subscription Renewal Delivered via Email
Add to Cart $ 832.95 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal Delivered via Email

dotConnect for Oracle Developer Subscription Renewals

Add to Cart $ 166.55 1 Developer License Subscription Renewal Delivered via Email
Add to Cart $ 391.95 4 Developer Team License Subscription Renewal Delivered via Email
Add to Cart $ 930.95 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal Delivered via Email

dotConnect for Oracle Standard Subscription Renewals

Add to Cart $ 68.55 1 Developer License Subscription Renewal Delivered via Email
Add to Cart $ 166.55 4 Developer Team License Subscription Renewal Delivered via Email
Add to Cart $ 460.55 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal Delivered via Email

dotConnect for Oracle Mobile Subscription Renewals

Add to Cart $ 88.15 1 Developer License Subscription Renewal Delivered via Email
Add to Cart $ 235.15 4 Developer Team License Subscription Renewal Delivered via Email
Add to Cart $ 558.55 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal Delivered via Email

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, including volume licensing and previous versions.

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

What’s new in dotConnect for Oracle V8.3.146?

  • Support added for ADO.NET implementation of ASP.NET Identity 2.0.
  • New IUserEmailStore, IUserPhoneNumberStore, IUserTwoFactorStore and IUserLockoutStore interfaces added to UserStore class.
  • Database server version added to generated Code-First Migrations scripts.

What’s new in dotConnect for Oracle V8.2.90?

  • OracleDataAdapter and OracleDataTable class performance improved.
  • Parameter performace improved
  • Reading and writing OracleObject attributes in OCI mode performance improved.

What’s new in dotConnect for Oracle V8.0.17?

  • Oracle 12c support.

What’s new in dotConnect for Oracle V7.9.333?

  • Visual Studio 2013 Release Candidate support.
  • SSIS DataFlow Source and Destination components for Oracle.
  • Direct mode OracleLoader support.

What’s new in dotConnect for Oracle V7.7?

  • Improved performance when working with TPT inheritance and retrieving descendants.
  • Disable query cache via the DataContext's 'EntityCachingMode' property.
  • Auto increment sequences and triggers for Oracle models.
  • New Data Transfer Object template for DTO class generation.

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

  • Visual Studio 2012 RC support
  • Implemented Initialization Command connection string parameter
  • Support for executing PL/SQL blocks using the OracleCommand.ExecuteArray method in Direct mode
  • Support for Batch Errors mode in the OracleCommand.ExecuteArray method in Direct mode

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

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

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

Product Search

Enter search words:

The Software Superstore for IT Professionals

As Official Distributors, ComponentSource offers convenient, one-stop shopping from 250+ Software Publishers specializing in Application Development & Operations.

More Info | About Us

Screenshot Gallery

Click for full screen preview

Screenshot of dotConnect for Oracle - .NET - V8.3.146 Screenshot of dotConnect for Oracle - .NET - V8.3.146 Screenshot of dotConnect for Oracle - .NET - V8.3.146 Screenshot of dotConnect for Oracle - .NET - V8.3.146 Screenshot of dotConnect for Oracle - .NET - V8.3.146
Award Award