Express Edition is a free data provider with basic connectivity features. Standard
Edition represents a fully-featured ADO.NET data provider with design time support
and advanced classes.
The following list briefly enumerates main advantages of Standard Edition.
To deploy an application written with dotConnect for Oracle, you need to:
For the detailed description of each of these steps, please refer to the
Licensing topics in dotConnect for Oracle help.
In the 5.0 release there were some important name changes in the product. Particularly,
assemblies, namespaces, invariant name, and some types were changed as follows:
"CoreLab.Data" became "Devart.Data";
"CoreLab.Oracle" became "Devart.Data.Oracle";
"OracleDirectFactory" became "OracleProviderFactory";
Invariant name became "Devart.Data.Oracle";
Your projects must be updated to be compatible with dotConnect for Oracle 5.0. Here
is the list of files you should update:
*.csproj, *.vbproj - references to assemblies
*.cs, *.vb - namespaces
*.licx - namespaces and assembly names
Web.config - assembly names and web provider types
This is done automatically when you invoke the Upgrade wizard from Visual Studio
menu: Tools | Oracle | Upgrade Wizard.
Devart data providers use a common assembly (Devart.Data.dll), so it is necessary
to install compatible providers versions. We release our ADO.NET data providers
in a single pack, thus releases from the same date should be compatible. Also, Devart
data providers should warn you before installation if an incompatible version of
Devart.Data.dll was detected.
You should put the Devart.Data, Devart.Data.Oracle, and Devart.Data.Oracle.Entity
assemblies in the Bin folder of your application (or place these assemblies in Global
Assembly Cache). Make sure that your application is licensed correctly (take a look
at the Licensing
article for more information).
Information about provider registering is available in the
Since dotConnect for Oracle 4.00, all upgrades to future versions are free for users
with an active dotConnect for Oracle Subscription.
Users that have a registration for versions of dotConnect for Oracle prior to OraDirect
.NET 4.00 can upgrade to dotConnect for Oracle 5.00 to jump in on the Subscription
The dotConnect for Oracle Subscription Program
is an annual maintenance and support service for dotConnect for Oracle users.
Users with a valid dotConnect for Oracle Subscription get the following benefits:
Priority Support is an advanced product support program which offers you
expedited individual assistance with dotConnect for Oracle-related questions from
the dotConnect for Oracle developers themselves. Priority Support is carried out
over email and has a two business day response policy.
The dotConnect for Oracle Subscription Program is available for registered users
of dotConnect for Oracle 4.00 and higher.
Yes, you can. dotConnect for Oracle version licenses are perpetual.
This generally indicates that license information could not be found, or you try
to apply it in some way that does not suit the kind of application. For example:
To fix the problem determine type of your application and read corresponding section
This means that license information was found but it is incorrect. It usually happens
in the following cases:
If you encounter one of these problems, do the following (the numbers of actions
correspond to the numbers of the problems in the above list):
If this does not help, send a small compiled binary with sources to our support
address, so we can investigate the problem in more details.
To support server-side compilation you ought to have special assembly App_Licenses.dll
in the Bin directory of your site. To create this assembly execute Build
Runtime Licenses command in the licenses.licx file context menu in the Solution
Explorer view. Required assembly will be created automatically.
Note that this is not necessary for precompiled ASP.NET applications (if nothing
is compiled on server by user request). Precompiled applications are licensed as
To do this install dotConnect for Oracle on same computer where SQL Server 2008
If any problems with licensing occurred in your project, you should use the License
Information dialog to resolve them. You can access it from the Visual Studio menu:
Tools | Oracle | License Information.
TYPE PLSQLTableType IS TABLE OF VARCHAR2(20) INDEX BY BINARY_INTEGER;
TYPE NESTEDTABLEType1 IS TABLE OF VARCHAR2(20);
TYPE NESTEDTABLEType2 IS TABLE OF OBJECTTYPE;
TYPE VARRAYTYPE AS VARRAY(3) OF VARCHAR2(20);
OracleDataReader r = ((OracleCursor)p.OracleValue).GetDataReader();
DataSet ds = new DataSet();
This is a known Oracle feature. It does not recognize the fields from the outer
query in the subquery. For example, the following query leads to this error:
SELECT "Extent1".DEPTNO AS ID
FROM DEPT "Extent1"
WHERE EXISTS (
1 AS C1
FROM ( SELECT
"Extent2".EMPNO AS ID
FROM EMP "Extent2"
WHERE "Extent1".DEPTNO = "Extent2".DEPTNO
This behavior was changed in Oracle 10.2.0.1, and these changes were rolled back
in the further Oracle versions.
We've been using dotConnect for Oracle for several years now. You have a terrific
product and excellent support (at very reasonable prices)...
Progressive Data Systems, Inc.
Visual Studio 2013 Support in Devart .NET Connectivity Solutions!
Support for Oracle 12c and Sync Framework in Devart .NET Connectivity Solutions!
dotConnect Data Providers Join the High Five Program!
You might be also interested in:
Oracle management tools:
ADO.NET providers for:
Oracle data access in other technologies: