dotConnect for Oracle Features

Table of Contents

  1. General usability
  2. Network and connectivity
  3. Compatibility
  4. Oracle technology support
  5. Oracle data types support
  6. Performance
  7. ADO.NET technology support
  8. ADO.NET Entity Framework
  9. LinqConnect (formerly known as LINQ to Oracle)
  10. Workflow Foundation Support
  11. Extended data access technologies and functionality
  12. Business Intelligence Solutions Support
  13. WinForms-specific features
  14. ASP.NET-specific features
  15. Script execution
  16. SQL execution monitoring
  17. Design-time enhancements
  18. dbForge Fusion for Oracle main features
  19. Product clarity
  20. Licensing and support

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

Network and connectivity


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
  • Microsoft Visual Studio 2008, 2010, 2012, and 2013 support
  • CodeGear Delphi 2007 support
  • Embarcadero Delphi Prism support
  • SQL Server 2008 Business Intelligence Solutions support
  • Publisher policy files for versions compatibility
  • Sync Framework support

Oracle technology support


Oracle data types support


Performance

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

ADO.NET technology support


ADO.NET Entity Framework

  • Conceptual approach to enterprise development
  • High performance
  • Wide support for LINQ to Entities
  • Entity Framework Code First support
  • Entity Framework Code First Migrations support
  • Wide support for EntitySQL
  • Full CRUD (Create, Retrieve, Update, Delete) support
  • Wide support for server data types
  • Entity Framework Spatials support
  • 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
  • Full-text search support
  • Visual Studio EDM Wizard support
  • Reverse engineering of database objects to entity model
  • Support for most Entity Framework Canonical Functions
  • Visual model creation and code generation with Entity Developer
    • Update Model From Database functionality for Entity Developer
    • Update To Database with Mapping Synchronization functionality for Entity Developer
  • Illustrated tutorial to get started with Entity Framework in 5 minutes

LinqConnect (formerly known as LINQ to Oracle)

  • 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
  • Ability to execute DML statements in batches on SubmitChanges
  • Fluent Mapping support
  • Complex type support
  • PLINQ support (connection manager redesigned for thread safety)
  • Support for different configurable algorithms for primary key generation
  • Inheritance mapping support (Table Per Hierarchy and Table Per Type)
  • Support of Visual Studio Debugger Visualizer for the DataQuery objects
  • ASP.NET Dynamic Data support with ASP.NET Dynamic Data project templates
  • Automatic configurable compiled query caching
  • 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
  • Server-independent interface
  • Visual model creation and code generation with Entity Developer
    • Update Model From Database functionality for Entity Developer
    • Update To Database with Mapping Synchronization functionality for Entity Developer
  • Illustrated tutorial to get started with LinqConnect in 5 minutes

Workflow Foundation Support


Extended data access technologies and functionality


Business Intelligence Solutions Support

  • SSIS DataFlow Source and Destination components
  • Analysis Services support
  • Reporting Services support

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


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


Design-time enhancements


dbForge Fusion for Oracle 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

Product clarity

  • Complete documentation sets integrated into Visual Studio and Embarcadero 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

Licensing and support

  • Included annual dotConnect for Oracle Subscription with Priority Support
  • Licensed royalty-free per developer, per team, or per site