What is dotConnect for Oracle used for?

It is a high-performance Object-Relational Mapping (ORM) enabled data provider for Oracle, built on ADO.NET technology. It presents a complete solution for development of Oracle-based database applications. Main advantages are boost in performance, productivity, and new approaches for application architecture design.

Does dotConnect for Oracle require Oracle Client?

Devart dotConnect for Oracle supports the Direct Mode, which enables the user's applications to work with Oracle diractly via TCP/IP, avoiding usage of Oracle Client altogether.

What types of secure connection are supported?

Devart dotConnect for Oracle supports multiple encryption algorithms, has OS and Proxy authentication, Oracle Data Integrity, and more.

dotConnect for Oracle

.NET 10 available

PM> Install-Package Devart.Data.Oracle

Supported Platforms

See in action

.NET Connector for Oracle With ORM Support

dotConnect for Oracle is a versatile enterprise-grade connector that enables direct access to Oracle data in .NET applications of all levels. It delivers advanced ORM support, compatibility with multiple Oracle versions and .NET platforms, and easy integration with a variety of IDEs, including Microsoft Visual Studio.

The connector undergoes regular security and performance testing to ensure reliability and consistent quality. It also includes premium support, frequent updates, and detailed documentation to help you get started quickly.

Direct access to data with no need for Oracle Client
Advanced ORM support: EF Core, Dapper, NHibernate, LinqConnect, and more
Full compliance with ADO.NET standards
Top performance with intelligent fetch block size control and batch processing
Support for high-end Oracle features: RAC, sharding, and advanced queuing
Comprehensive support for Oracle-specific data types and PL/SQL
Integration with Visual Studio

Direct connection
OCI connection

C# Copy code

using Devart.Data.Oracle;
class Program
{
  static void Main()
  {
    using OracleConnection conn = new(
      "Server=127.0.0.1;" +
      "Port=1521;" +
      "User Id=TestUser;" +
      "Password=TestPassword;" +
      "Service Name=orcl;" +
      "Direct=True;" +
      "License Key=**********");
    conn.Open();
  }
}

C# Copy code

using Devart.Data.Oracle;
class Program
{
  static void Main()
  {
    using OracleConnection conn = new(
      "Server=127.0.0.1;" +
      "User Id=TestUser;" +
      "Password=TestPassword;" +
      "License Key=**********");
    conn.Open();
  }
}

Direct connection to Oracle

dotConnect for Oracle allows connecting to Oracle Database via TCP/IP either directly or via Oracle Cloud Infrastructure, 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

Find out more

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, 8.0, 9.0

NHibernate

1.x-5.x

Entity Framework

v1-v6

Dapper

1.x, 2.x

Entity Developer used with various ORM technologies allows automatic creation of entity classes and the DbContext class, accelerating the development and ensuring that the data model stays synchronized with the database.

Explore the features

High performance

dotConnect for Oracle supports Oracle-specific features such as intelligent caching, DML batch processing, and LOB prefetching to help improve performance. It also manages connection pools efficiently, reducing the overhead of opening and closing connections, with dynamic pool size adjustment based on demand.

Find out more

Compatibility and integration

Platforms

.NET 5.0, 6.0, 7.0, 8.0, 9.0, 10.0
.NET Framework 2.0–4.8
.NET Core 2.0-3.1

Oracle Database

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

Visual Studio Extension

Data source connection
Database object explorer
Data retrieval and display

Compatibility with NuGet

Works in any NuGet-compatible IDE like VS Code, JetBrains Rider, etc.

Explore the features

Features

Advanced connection configuration

Easily manage Oracle database connections with tools like OracleConnectionStringBuilder and OracleCredential, enabling dynamic runtime configuration. Use Oracle environment management (OracleHome, OracleHomeCollection) and metadata access for flexible, multi-home Oracle database connectivity in complex .NET deployments.

Support for Oracle-specific
data types

Fully utilize Oracle's rich data types, including LOBs (OracleLob, OracleBFile), UDTs (OracleObject, OracleArray, OracleRef), and XML storage (OracleXml). dotConnect simplifies working with custom Oracle structures and offers strong .NET mapping for safer, more productive development.

Bulk data operations and backups

Streamline data migration and ETL processes with OracleLoader, which provides high-performance bulk data loading capabilities. Create and manage database backups with built-in scripting support (OracleScript, OracleSqlStatementCollection), simplifying maintenance and preserving data integrity across environments.

Secure connectivity
and configuration

Ensure robust security and high availability for mission-critical applications with built-in support for SSH tunneling, SSL encryption, and advanced connection failover handling (OracleFailoverEventsArgs). dotConnect also integrates tightly with Oracle RAC and supports transparent application failover for continuous availability.

Event-driven monitoring
and change tracking

Build responsive applications with Oracle-specific event-driven APIs. Use OracleDependency for query notifications, OracleAlerter and OracleAlert for DBMS_ALERT integration, and OracleQueue for Advanced Queuing (AQ). Track SQL execution and collect performance diagnostics with OracleMonitor and OracleTrace for precise runtime monitoring.

Development wizards
in Visual Studio

Enhance Oracle development with Visual Studio wizards for connections, DataSets, and migrations to boost productivity and simplify database tasks.

View all features

Leading companies choose dotConnect

Success stories from our customers

Other .NET connectors for databases

Your universal ADO.NET provider for multiple database systems

dotConnect Universal

dotConnect Universal offers universal access to data of different databases for the Microsoft .NET Framework. It supports the most popular database servers, including Microsoft SQL Server, Microsoft Access, Oracle Database, DB2, MySQL, PostgreSQL, SQLite, InterBase, and Firebird. Other servers can be accessed through their ADO.NET, OLE DB and ODBC providers.

$269.95

Developer edition

Buy now

Useful articles

Connect to Oracle in .NET

Explore how to establish a connection between .NET applications and an Oracle database using ADO.NET.

Connect to Oracle with EF Core

Find out how to connect an Oracle database to your application using EF Core and ADO.NET.

Connect to Oracle with Dapper

Learn how to connect C# to Oracle using Dapper for fast and efficient data access and management.

Get started with dotConnect for Oracle at no cost

Download our connector for a FREE, fully-functional trial and take data access to the next level today!

Download for free

Try dotConnect Universal

Enable universal access to data from different database systems, including Microsoft SQL Server, Microsoft Access, Oracle, DB2, MySQL, PostgreSQL, SQLite, InterBase, and Firebird.

Get now

Need a hand?

If you need any help or have questions about our tools or purchasing options, just let us know. Our response won't keep you waiting.

Contact support

Try the 30-day trial of the full product. No limits. No card required. Start free trial