dotConnect for Oracle Features

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

  • 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

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

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 [New]
  • Entity Framework Code First Migrations support [New]
  • 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
    • 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
  • 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

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, Role, Session State, Profile, Personalization, Site Map, Web Event
  • 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

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
ADO.NET Data Provider for Oracle