dotConnect for Oracle, formerly known as OraDirect .NET, is an enhanced data provider for Oracle that builds on ADO.NET technology to present a complete solution for developing Oracle-based database applications. As part of the Devart database application development framework, dotConnect for Oracle offers both high performance native connectivity to the Oracle database and a number of innovative development tools and technologies. dotConnect for Oracle introduces new approaches for designing application architecture, boosts productivity, and leverages database application implementation.
dotConnect for Oracle is a scalable data access solution developed with wide adaptability in mind. It can be successfully used in WinForms, ASP.NET, two-tier, multi-tier applications; within the ASP.NET Provider Model; in conjunction with the Enterprise Library; under .NET Compact Framework, Mono Framework and so on. Depending on the edition you choose, dotConnect for Oracle can be used as a powerful ADO.NET data provider, or an effective application development framework.
dotConnect for Oracle is actively developed and supported by the Devart. If you have questions about dotConnect for Oracle, email the developers at [email protected] or visit dotConnect for Oracle online at https://www.devart.com/dotconnect/oracle/.
Wide Coverage of Oracle Features
By providing access to the most advanced database functionality, dotConnect for Oracle allows developers to harness the full capabilities of the Oracle server and optimize their database applications. dotConnect for Oracle stands out as the set of components with the widest support of Oracle functionality. Get a full list of supported Oracle features in the Features topic.
Flexible Connectivity
dotConnect for Oracle offers two connection modes to 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 that use other data connectivity solutions.
Optimized Code
The goal of dotConnect for Oracle is to enable developers to write efficient and flexible database applications. The dotConnect for Oracle assemblies are implemented using optimized code and advanced data access algorithms. Components undergo comprehensive performance tests and are designed to help you write thin and efficient product data access layers.
Comprehensive Support for ADO.NET Technology Features
dotConnect for Oracle supports new ADO.NET features and technologies as soon as they are released. This includes base-class-based provider model, provider factories, connection string builder, metadata schemas, asynchronous commands, pooling enhancements, batch update support, provider-specific types, server enumeration, database change notification support and so on. dotConnect for Oracle will continue supporting the newest standards and innovations of the .NET Framework.
Database Application Development Extensions
dotConnect for Oracle has rich set of design time tools that leverage the development process greatly. Particularly, there are convenient design time component editors, wizards and managers for typed Oracle-specific components, toolset for live data binding and much more. dotConnect for Oracle integrates tightly with Visual Studio 2008 - 2022, Delphi, and SQL Server 2008 - 2023 Business Intelligence Solutions. Last, but not least, there is dbForge Fusion for Oracle to design your database schema and manage table data - all within your favorite IDE.
Oracle Advanced Features Support
dotConnect for Oracle has extra components designed to simplify some tasks and support Oracle-specific technologies. Particularly, OracleScript serves to execute series of SQL statements, OracleLoader serves to load external data into Oracle databases with use of Direct Path API, OracleAlerter and OraclePipe transfer messages and data between connections or client applications, and so on. dotConnect for Oracle includes set of classes designed to work with Oracle Advanced Queuing technology.
ADO.NET Entity Framework Support
ADO.NET Entity Framework is a conceptual approach to database application development with focus on objects instead of relational data. The flexible architecture of Entity Framework is made up of well-thought layers and modules. Entity Framework optimizes the development process with object-relational mapping, SQL-based entity query language, and LINQ. Entity Framework Core is a new, modernised and rewritten version of Entity Framework.
dotConnect for Oracle fully supports the Entity Framework capabilities, which allows you to base your object-oriented applications on Oracle. dotConnect for Oracle includes a wizard that helps you setup model relations, and a set of demos to use as a starting point. All standard Entity Framework samples can be easily ported to dotConnect for Oracle. dotConnect for Oracle supports both Entity Framework and Entity Framework Core.
LinqConnect Support
Much like Entity Framework, LinqConnect is an entity-oriented data access technology with focus on objects instead of relational data. LinqConnect is easier to start with, it supports more of server features, and adds less complications to your code. LinqConnect is backed up by Entity Developer to visually design the application entity model and database objects.
Both Connected and Disconnected Models
dotConnect for Oracle combines connected and disconnected data access models in single OracleDataTable component, which allows you to design more flexible application architecture and use full power of data binding.
Development and Support
dotConnect for Oracle is a Oracle connectivity solution that has been actively developed and supported since 2002. dotConnect for Oracle comes with full documentation, demo projects, and fast (usually within one business day) technical support by the dotConnect for Oracle development team. Find out more about how to get help or submit feedback and suggestions in the Getting Support topic.
A description of the dotConnect for Oracle components is provided in the Class and Component List.
For the detailed list of dotConnect for Oracle features refer to the Features topic.