OraDirect .NET Overview
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, OraDirect .NET offers both high performance native connectivity to the Oracle database and a number of innovative development tools and technologies.
OraDirect .NET introduces new approaches for designing application architecture, boosts productivity, and leverages database application implementation.
Download trial
Advantages of OraDirect .NET
Wide Coverage of Oracle Features
By providing access to the most advanced database functionality, OraDirect .NET allows developers to harness the full capabilities of the Oracle server and optimize their database applications. OraDirect .NET stands out as the set of components with the widest support of Oracle functionality.
Flexible Connectivity
OraDirect .NET offers two connection modes to the Oracle server: connection through the Oracle Call Interface and direct connection over TCP/IP. Applications written with OraDirect .NET 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 OraDirect .NET is to enable developers to write efficient and flexible database applications. The OraDirect .NET 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
OraDirect .NET 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. OraDirect .NET will continue supporting the newest standards and innovations of the .NET Framework.
Database Application Development Extensions
OraDirect .NET 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. OraDirect .NET integrates tightly with Visual Studio 2005/2008, Delphi, and SQL Server 2005 Business Intelligence Solutions. Last, but not least, there is OraDeveloper Tools to design your database schema and manipulate table data - all within your favorite IDE.
Oracle Advanced Features Support
OraDirect .NET 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. OraDirect .NET 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.
OraDirect .NET fully supports the Entity Framework capabilities, which allows you to base your object-oriented applications on Oracle. OraDirect .NET includes a set of demos to use as a starting point. All standard Entity Framework samples can be easily ported to OraDirect .NET.
LINQ Support
OraDirect .NET includes support for LINQ to Oracle technology (currently in Beta as a standalone package). The technology allows you to employ object-oriented database application development with less efforts and in less time. Compared to ADO.NET Entity Framework, LINQ to Oracle is better suited for RAD-style development, is easier to start with, and somewhat richer with server-oriented features like server-specific types.
Both Connected and Disconnected Models
OraDirect .NET 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.
Key Features
The following list describes the main features of OraDirect .NET.
- Direct access mode (without Oracle client)
- 100% managed code
- High performance
- Easy to deploy
- Supports the latest versions of Oracle server, including Personal and Express editions
- All Oracle data types support
- Full Oracle Objects support
- Comprehensive REF CURSOR support
- PL/SQL tables and PL/SQL records support
- .NET Compact Framework support
- Entity Framework support
- Operates in both connected and disconnected models
- Powerful OracleDataTable component as all-in-one table data access solution
- Typed OraclePackage component for wrapping PL/SQL packages
- Auxiliary components for SQL scripts and bulk data transfer
- Extra data binding capabilities
- Cross-form components cooperation
- Ability of monitoring query execution
- Licensed royalty-free per developer, per team, or per site
Editions
OraDirect .NET has four editions: Professional, Standard, Mobile, and Trial. The Standard Edition represents a fully-featured ADO.NET data provider with design time support and advanced classes. The Professional Edition adds more classes, tools, technologies, and integration capabilities, including OraDeveloper Tools, an advanced add-in for designing databases and easily manipulating data and schema objects from your IDE. The Mobile Edition is equivalent to the Standard Edition for .NET Compact Framework. The Trial Edition corresponds to Professional with trial limitation.
| Feature | Professional | Standard | Mobile | Trial |
|---|---|---|---|---|
| .NET Framework support | + | + | + | |
| .NET Compact Framework support | + | + | ||
| ADO.NET core classes | + | + | + | + |
| Native data types classes and structures | + | + | + | + |
| OracleDataSet class | + | + | ||
| OracleDataTable class | + | + | ||
| OracleScript class | + | + | + | + |
| OracleLoader class | + | + | ||
| OraclePackage class | + | + | ||
| OracleAlerter class | + | + | ||
| OraclePipe class | + | + | ||
| OracleTrace class | + | + | ||
| DataLink class | + | + | ||
| Design-time features, including component editors and property editors | + | + | + | + |
| Oracle Advanced Queue technology support | + | + | ||
| Entity Framework support | + | + | ||
| Enterprise Library support | + | + | ||
| ASP.NET 2.0 providers support | + | + | ||
| Advanced Visual Studio 2005/2008 integration (Server Explorer and other features) |
+ | + | + | |
| DataSet Manager and Editor | + | + | ||
| DataSet Wizard | + | + | ||
| Migration Wizard | + | + | + | |
| SQL Server 2005 Business Intelligence Solutions support | + | + | ||
| OraDeveloper Tools | + | + | ||
| OracleMonitor class | + | + | + | + |
| DBMonitor support | + | + | ||
| Trial limitation* | + |
* Trial version of the provider is a fully working version during 30 days period.
Compatibility
OraDirect .NET supports Oracle servers 11g, 10g, 9i, 8i, 8.0 and 7.3, including Personal and Express editions. OraDirect .NET supports both x86 and x64 versions of the following Oracle clients: 11g, 10g, 9i, 8i and 8.0. The provider works with .NET Framework 1.0, 1.1, 2.0, 3.0, 3.5, and .NET Compact Framework 1.1 and 2.0, and can be used with the following development environments:
|
 
|
OraDirect .NET can be used together with UniDirect .NET that provides universal access to different databases within a single code.
OraDeveloper Tools for OraDirect .NET
OraDirect .NET Professional Edition includes OraDeveloper Tools.
OraDeveloper Tools is a powerful tool designed to automate and simplify Oracle database development process. It integrates into Microsoft Visual Studio .NET and Borland Delphi making all database development and administration tasks available from your favorite IDE. It provides an easier way to explore and maintain existing databases, design compound SQL statements, query and manipulate data in different ways.
Main advantages of OraDeveloper Tools are:
- Convenient server browsing
- Simplified database objects creating and altering
- Advanced SQL handling
- Powerful data editing
- Wide support of Oracle server objects
- Direct access to Oracle server
- Extra design-time capabilities
- Help integrated into IDE
OraDeveloper Tools is also available as standalone application. For more information on the product please refer to OraDeveloper Tools pages.
