dotConnect for Oracle

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.

Key Features
* 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.

• Flexible Connectivity
  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.

• Optimized Code
  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.

• Compatibility
  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 9.2.0.4 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.

• LinqConnect
  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.

• BIS Support
  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.

• Development Environments

• Visual Studio 2022

• Visual Studio 2019

• Visual Studio 2017

• Visual Studio 2015

• Visual Studio 2013

• Visual Studio 2012

• Visual Studio 2010

• Visual Studio 2008

• Security

• 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