| 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
|
|
|
