OraDirect .NET Features

General usability

  • Direct access to server data. OraDirect .NET 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

Network and connectivity

  • In Direct mode does not require Oracle Client Software and works directly through TCP/IP
  • Both connected and disconnected data access models
  • Support for setting connection timeout values for Direct mode
  • OS authentication
  • DBA privileges to open a session with
  • Proxy Authentication support [New]
  • Unicode connections

Compatibility

  • Full support of the latest versions of Oracle, including Personal and Express editions
  • Support for all versions of Oracle Clients, including Instant Client
  • Full support for x64 architecture
  • .NET Compact Framework support
  • Mono Framework support
  • Visual Studio .NET 2002, 2003, 2005, and 2008 support [Improved]
  • Borland Delphi 8, 2005, 2006, Turbos support
  • SQL Server 2005 Business Intelligence Solutions support [Improved]
  • Publisher policy files for versions compatibility

Oracle technology support

  • Oracle Advanced Queuing support
  • Oracle package support with powerful OraclePackage component
  • Ability to manage alerts with OracleAlerter class
  • Ability to use pipes with OraclePipe class
  • Support for Direct Path interface with OracleLoader component
  • Ability to perform SQL and PL/SQL tracing with OracleTrace class
  • Support for Oracle Change notifications functionality of Oracle 10g
  • Oracle Transparent Application Failover support
  • Multiple Oracle Homes support
  • DML array operations support
  • Direct LOB access support [Improved]
  • Temporary LOB management routines
  • Temporary LOBs for updating LOB fields
  • Miscellaneous LOB management modes
  • OCI Connection Pooling [New]
  • Statement Caching
  • ROWID values retrieval
  • Overloaded stored procedures support
  • OracleGlobalization for managing culture settings

Oracle data types support

  • All Oracle data types support
  • TIMESTAMP and INTERVAL data types support
  • PL/SQL table support
  • PL/SQL records support
  • Support for REF CURSORs, including IN, OUT, and IN/OUT
  • Oracle Object (including NOT FINAL objects) types support
  • Nested table support
  • Objects handling in both connected and disconnected modes
  • XMLTYPE data type support

Performance

  • High overall performance
  • Intelligent fetch block size control
  • Advanced connection pooling
  • High performance batch processing

ADO.NET technology support

  • Full support for ADO.NET Entity Framework [New]
  • Server enumeration
  • Batch update support
  • Extended metadata information retrieval
  • Advanced CommandBuilder component with automatic refresh SQL [Improved]
  • Enhanced pooling control through connection string
  • Connection string builder
  • Provider factory for generating key data access classes
  • Asynchronous command execution
  • Provider-specific types support [Improved]
  • Password change API
  • Database Change Notification Support
  • OracleCommand execution cancelling support

Extended data access technologies and functionality

  • Powerful OracleDataTable component for manipulating individual tables or query result
  • Structural representation and editing of Oracle objects
  • NonBlocking mode allows fetching data asynchronously in the background
  • Fill DataSet with several REF CURSOR
  • Fill DataSet with object, array and nested table data
  • On-demand data fetch for data-bound controls
  • Paginal access to query result
  • Server side master-detail relation based on queries
  • Ability to refresh individual records in OracleDataTable component
  • Support for Enterprise Library Data Access Application Block (DAAB)
  • Object-oriented building of SELECT statements
  • Extended warning and error information retrieval [Improved]
  • Extended interface for processing execution exceptions
  • OracleDataAdapter.Fill method with sequential fetch support
  • Ability to defer fetching of some columns in a resultset
  • Custom Oracle Object mapping with ICustomOracleObject interface

WinForms-specific features

  • Flexible data binding with DataLink component
  • InterForm technology for cross-form components cooperation
  • Oracle Object data binding Support
  • Global position synchronization within a data source

ASP.NET-specific features

  • ASP.NET data providers: Membership provider, Role provider, Session State provider, Profile provider
  • OracleDataSource web component
  • OracleCacheDependency component to control Cache item dependencies in ASP.NET applications

Script execution

  • Advanced script execution features with OracleScript component
  • Support for executing individual statements in scripts
  • Support for executing huge scripts stored in files with dynamic loading
  • Ability to use standard SQL*Plus tool syntax in scripts

SQL execution monitoring

  • Extended SQL tracing capabilities with OracleMonitor component
  • Support for DBMonitor utility for advanced tracing analysis and control
  • Per-component SQL tracing
  • Optional log output to IDE toolwindows

Design-time enhancements

  • Automatic component registration in toolbox
  • Advanced integration with Visual Studio 2005/2008, including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder and configuring web component OracleDataSource
  • DataSet Wizard to create and edit typed Oracle-oriented datasets
  • DataSet Manager to list and bind datasets in the project [Improved]
  • DataSet Editor to edit dataset contents
  • Oracle Package Wizard that simplifies working with PL/SQL Packages
  • Oracle Object Wizard that simplifies working with Oracle Objects
  • Advanced design-time component and property editors
  • IntelliSense descriptions for OraDirect .NET classes
  • Easy migration from MS OracleClient and ODP.NET with Migration Wizard
  • Syntax highlighting in design-time editors
  • TableMappings editor
  • Convenient instant data preview and management in design time

OraDeveloper Tools main features

  • Integration with OraDirect .NET for enhanced component designers and drag and drop features
  • PL/SQL debugger
  • SQL code completion and navigation
  • Visual query builder
  • Database Explorer
  • Visual object editors
  • Database search engine
  • Code template library
  • Security Manager
  • Session Manager
  • Export/Import Wizards

Product clarity

  • Complete documentation sets integrated into Visual Studio .NET and Borland Delphi
  • Integration with Visual Studio and MSDN help collections
  • Documentation available as a standalone chm file
  • A large amount of helpful demos in C#, VB, C++, and Delphi [Improved]

Licensing and support

  • Included annual OraDirect .NET Subscription with Priority Support
  • Licensed royalty-free per developer, per team, or per site