dotConnect for Oracle

.NET Connector for Oracle with ORM Support

dotConnect for Oracle is a versatile, high-performance .NET connector that offers direct access to Oracle Database with no need for Oracle Client. It fully complies with ADO.NET standards, supports advanced ORM with Entity Framework and LinqConnect, and ensures optimal application performance through intelligent fetch and batch processing. The connector boasts comprehensive security features, broad compatibility with Oracle versions and .NET platforms, and seamless integration with Visual Studio.

Features

Direct access to data without Oracle Client
ORM support with Entity Framework and LinqConnect
High performance with intelligent fetch block size control and batch processing
Robust security features, including advanced encryption and data integrity
Compatibility with different Oracle versions and .NET platforms
Support for high-end Oracle features like RAC, sharding, and advanced queuing
Comprehensive support for Oracle-specific data types and PL/SQL
Integration with Visual Studio and design-time support

Full list of features

Compatibility

The following table show which version of this package to use with which version of frameworks.

Frameworks	Version support
Entity Framework Core	8, 7, 6, 5, 3, 2, 1
.NET	8, 7, 6, 5
.NET Core	3, 2, 1
.NET Framework	4.8, 4.7, 4.6, 4.5

More information here

Usage

To establish a connection to server you have to provide some connection parameters to dotConnect for Oracle. This information is used by the OracleConnection component to find the server and login with credentials of your account. The parameters are represented as connection string. You can compose the connection string manually or have dotConnect for Oracle construct it for you.

There are two ways to connect to server: with and without Oracle Client Interface. This is controlled by Direct property. It indicates whether the Oracle Client Interface will be used for connecting to server. By default Direct mode is disabled to preserve maximal functionality. Switch to Direct mode if you want to work in a system without Oracle Client Software installed.

This snippet directly configures a Oracle connection using a connection string.

using Devart.Data.Oracle;
...
OracleConnection oracleConnection = new OracleConnection();
oracleConnection.Server = "OraServer";
oracleConnection.UserId = "scott";
oracleConnection.Password = "tiger";

Read the full documentation for connection here.

Direct Connection to Oracle

dotConnect for Oracle allows connecting to Oracle Database via TCP/IP without any need for Oracle Client, which greatly simplifies application development and deployment.

Easy connection without Oracle Client
Full support for Oracle-specific data types
Robust security with advanced encryption and authentication
Flexible connectivity options for diverse operational environments
Cost-effective deployment

Advanced ORM Support

dotConnect for Oracle offers enhanced ORM support with a bundled visual designer for ORM models - Entity Developer. Our Oracle ADO.NET provider supports the following ORM solutions:

Entity Framework Core: 1.x, 2.x, 3.x, 5.0, 6.0, 7.0, and 8.0
NHibernate: 1.x-5.x
Entity Framework: v1-v6
LinqConnect LINQ to SQL solution by Devart

High Performance

dotConnect for Oracle is no stranger to Oracle-specific features such as intelligent caching, DML batch processing, and LOB prefetching, which can greatly enhance performance. Additionally, efficient management of connection pools reduces the overhead of establishing and closing connections. This includes dynamic adjustment of pool size based on demand.

Broad Compatibility

dotConnect for Oracle is the only Oracle provider that supports all modern platforms and technologies—like .NET Core and Entity Framework Core—as well as multiple deprecated technologies, which will reduce the cost of supporting existing applications.

Platforms

.NET 5, 6, 7, 8
.NET Framework 2.0–4.8
.NET Core 1.x, 2.x, and 3.0
.NET Compact Framework 2.0 and higher
Mono 2.0 and higher

Oracle Database

All versions from 8 to 23c
Oracle TimesTen
Oracle Cloud (DBaaS)

Microsoft Visual Studio 2008-2022

License

See pricing options for ordering.

Trial Limitations

The dotConnect for Oracle Evaluation License lets you try dotConnect for Oracle Trial Edition for a period of 30 days. You may not use applications developed using Trial versions of the Software for any commercial purposes.

Devart Software