Feature-rich ADO.NET provider with ORM support
dotConnect for Oracle is a powerful database connectivity solution based on the ADO.NET architecture and a development framework with many options for developing database-related applications and websites. Such ORM solutions as Entity Framework and LINQ to SQL introduce innovative designing approaches and boost the database application development productivity.
* Wide Coverage of Oracle Features
Access to the most advanced database functionality, lets the developers harness the full capabilities of the Oracle server and optimize the database applications. dotConnect for Oracle supports HA events from Oracle RAC, Oracle Transaction Guard, and Connection pool performance counters.
Two connection modes are supported for the Oracle server: connection through the Oracle Call Interface and direct connection over TCP/IP. Applications written with dotConnect for Oracle are easy to deploy, do not require installation of Oracle Client Software, and tend to be faster than those using other data connectivity solutions.
The dotConnect for Oracle assemblies are implemented using optimized code and advanced data access algorithms.
Comprehensive Support for ADO.NET Technology Features
dotConnect for Oracle supports new ADO.NET features and technologies as soon as they are released.
Database Application Development Extensions
dotConnect for Oracle has convenient design-time component editors, wizards, and managers for typed Oracle-specific components, a toolset for live data binding, and much more. It integrates with Visual Studio 2008 / 2010 / 2012 / 2013 / 2015/ 2017 /2019, Visual Studio LightSwitch 2011 and 2012, Delphi, and SQL Server 2016 Business Intelligence Solutions.
Visual Studio 2022 support
dotConnect for Oracle version 10.0 grants full support for Visual Studio 2022 (version 17.2 and version 17.3 Preview). You can use all features of this Microsoft IDE.
Oracle Advanced Features Support
The solution supports Oracle-specific technologies. Particularly, OracleScript executes a series of SQL statements, OracleLoader loads external data into Oracle databases with the use of Direct Path API, OracleAlerter and OraclePipe transfer messages and data between connections or client applications, etc. There is a set of classes designed to work with Oracle Advanced Queuing technology.
Full support is provided for .NET Frameworks 2.0, 3.0, 3.5, 4.0, 4.5, 4.6, 4.7, 4.8, .NET 5, .NET 6 and .NET Compact Framework. Also, dotConnect for Oracle supports Mono version 2.0 and above. The product is compatible with ADO.NET Entity Framework v1 - v6.4 and Entity Framework Core 1.1, 2.2, 3.1, and 5. Since version 10.0, it also supports .NET 6 and providers full Visual Studio 2022 support. (Oracle server 126.96.36.199 or higher is required for Entity Framework). Additionally, dotConnect for Oracle provides .NET Standard 1.3 compatible assemblies, which are compatible with .NET Core 1.x, 2.x and 3.0, NET Framework 4.6 and higher, and .NET Standard 2.0. Also, the assemblies are compatible with .NET Core 2.0 and higher and .NET Framework 4.6.1 and higher.
ADO.NET Entity Framework Support
dotConnect for Oracle supports all the Entity Framework versions - Entity Framework v1, v4, v5, and v6 and Entity Framework Core 1.1, 2.2, 3.1, 5.0, and 6.0.
The support for LINQ to Oracle technology allows you to develop object-oriented database applications much faster and easier.
Connected and Disconnected Models
dotConnect for Oracle combines connected and disconnected data access models in a single OracleDataTable component. It allows for designing a more flexible application architecture with the full power of data binding.
You can use the provider in SQL Server Business Intelligence Solution (BIS) projects. It offers native Devart Oracle Source and Devart Oracle Destination components for Data Flows in Integration Services projects. Also, it supports Reporting Services and Analysis Services projects, including SQL Server 2016 Business Intelligence.
Visual Studio 2022
Visual Studio 2019
Visual Studio 2017
Visual Studio 2015
Visual Studio 2013
Visual Studio 2012
Visual Studio 2010
Visual Studio 2008
OS authentication (NTLM)
Proxy Authentication support
Oracle Data Encryption
Oracle Data Integrity
Support for encryption algorithms: RC4, RC4-56, RC4-128, RC4-256, DES-40, DES-56, DES-112, DES-168, AES-128, AES-192, AES-256
Support for checksum algorithms: MD5, SHA1, SHA256, SHA384, SHA512
Full support for operation in the FIPS 140-2 mode in Windows
SSL/TLS encryption support
SSH encryption support
Passing credentials via OracleCredential class, based on SecureString
Direct access to server data. dotConnect for Oracle can be used without Oracle Client Software.
Real RAD for database applications
Fully compliant with ADO.NET
100% managed code
Highly usable design time support
Easy to deploy
Easy to update to a new version via NuGet packages