dotConnect for DB2 Features

General usability

  • Real RAD for database applications
  • Fully compliant with ADO.NET
  • 100% managed code
  • Highly usable design time support
  • Easy to deploy
  • All DB2 data types support

Compatibility

  • Full support of the latest versions of DB2
  • Full support for x64 architecture
  • Microsoft Visual Studio 2008, 2010, 2012, and 2013 support
  • CodeGear RAD Studio 2007 support
  • Embarcadero Delphi Prism support
  • SQL Server 2008 and 2012 Business Intelligence Solutions support
  • Sync Framework support

ADO.NET technology support

  • Advanced support for ADO.NET Entity Framework v1, v4, v5, and v6
  • Batch update support
  • Extended metadata information retrieval
  • Enhanced pooling control through connection string
  • Connection string builder
  • Provider factory for generating key data access classes
  • Asynchronous command execution
  • Provider-specific types 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
  • 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
  • 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

Extended data access technologies and functionality

  • Powerful DB2DataTable component for manipulating individual tables or query result
  • NonBlocking mode allows fetching data asynchronously in the background
  • On-demand data fetch for data-bound controls
  • Paginal access to query result
  • Server side master-detail relation based on queries
  • 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
  • DB2DataAdapter.Fill method with sequential fetch support
  • Ability to defer fetching of some columns in a resultset
  • Named parameters support

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
  • Global position synchronization within a data source

ASP.NET-specific features

Script execution

  • Advanced script execution features with DB2Script component
  • Support for executing individual statements in scripts
  • Support for executing huge scripts stored in files with dynamic loading

SQL execution monitoring

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

Design-time enhancements

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

Licensing and support

  • Included annual dotConnect for DB2 Subscription with Priority Support
  • Licensed royalty-free per developer, per team, or per site
ADO.NET Provider for DB2