dotConnect for Oracle 5.20

dotConnect for Oracle 5.20 is professionally designed as a 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.

Major Advantages:

1. 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.
   
2. 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.
   
3. 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.
   
4. 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.
   
5. 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 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.
   
6. 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.
   
7. 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.
   • 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 set of demos to use as a starting point. All standard Entity Framework samples can be easily ported to dotConnect for Oracle. See our Entity Framework tutorial for a quick start with the technology.
8. LINQ Support
   dotConnect for Oracle includes support for LINQ to Oracle technology. 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. See our LINQ to Oracle tutorial for a quick start with the technology.
   
9. 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.
   

Major Features:

1. General usability
   • Direct access to server data. dotConnect for Oracle 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
2. 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
   • Unicode connections
3. 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 2005 and 2008 support
   • SQL Server 2005 Business Intelligence Solutions support
   • Publisher policy files for versions compatibility
4. 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
5. Oracle Transparent Application Failover support
   • Multiple Oracle Homes support
   • DML array operations support
   • Direct LOB access support
   • Temporary LOB management routines
   • Temporary LOBs for updating LOB fields
   • Miscellaneous LOB management modes
   • OCI Connection Pooling
   • 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
6. 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
7. Performance
   • High overall performance
   • Intelligent fetch block size control
   • Advanced connection pooling
   • High performance batch processing
8. 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
   • Enhanced pooling control through connection string
   • Connection string builder
   • Provider factory for generating key data access classes
   • Asynchronous command execution
   • Provider-specific types support
   • Password change API
   • Database Change Notification Support
   • OracleCommand execution cancelling support
9. ADO.NET Entity Framework
   • Conceptual approach to enterprise development
   • High performance
   • Wide support for LINQ to Entities capabilities
   • Wide support for EntitySQL
   • Full CRUD (Create, Retrieve, Update, Delete) support
   • Wide support for server data types
   • Change tracking support
   • Object data caching
   • Inheritance mapping support (TPH, TPT, and TPCT models)
   • Capability to use stored procedures when manipulating data
   • Stored procedure import support
   • Ability to build database-independent applications
   • Visual Studio EDM Wizard support
   • Reverse engineering of database objects to entity model
   • Visual model creation and code generation with Entity Developer [New]
   • Illustrated tutorial to get started with Entity Framework in 5 minutes [New]
10. LINQ to Oracle  [New]
    • Easy to use
    • High performance
    • Interchangeable with Microsoft LINQ to SQL
    • Plain CLR classes used (no need to use a common base class)
    • Full CRUD (Create, Retrieve, Update, Delete) support
    • Change tracking support
    • Object data caching
    • Data binding support
    • Wide support for LINQ capabilities
    • Wide support for server data types
    • Load on demand (lazy load)
    • Database transactions support
    • Inheritance mapping support (table per hierarchy model)
    • Server-independent interface
    • Visual model creation and code generation with Entity Developer
    • Illustrated tutorial to get started with LINQ to Oracle in 5 minutes [New]
11. 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
    • 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
12. 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
13. ASP.NET-specific features
    • ASP.NET data providers: Membership, Role, Session State, Profile, Personalization, Site Map, Web Event
    • OracleDataSource web component
    • OracleCacheDependency component to control Cache item dependencies in ASP.NET applications
14. 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
15. 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
16. 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
    • DataSet Editor to edit dataset contents
17. 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 dotConnect for Oracle 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 dotConnect for Oracle 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
18. Product clarity
    • Complete documentation sets integrated into Visual Studio and CodeGear 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
19. Licensing and support
    • Included annual dotConnect for Oracle Subscription with Priority Support
    • Licensed royalty-free per developer, per team, or per site

Enhancements:

1. LINQ to Oracle
   • Supported extended errors processing
   • Supported DataLoadOptions class and Include method for tuning data loading
   • Supported DeferredLoadingEnable functionality
   • Supported function import
   • Supported stored procedures as insert/update/delete behavior
   • Supported user-defined functions in selection part of a query
   • Supported CreateDatabase() and DeleteDatabase() methods
   • Supported SqlMethods class
   • Supported returning new Dictionary from query
   • Removed redundant TRIM() function calls
2. Entity Developer 2.00
   • Supported Entity Framework
   • Supported stored procedures and functions for LINQ to SQL
   • Added naming rules for database objects
   • Added Visual Studio integration
   • Validation schema improved
   • Entity Framework Complex Type supported
   • Entity Framework Storage Model editing supported
   • Many-to-Many associations retrieving added
   • Usability improvements
   • Stability and performance improvements
     

Requirements: .NET Framework

WareSeeker Editor