dotConnect for DB2 Features

Table of Contents

  1. General usability
  2. Compatibility
  3. ADO.NET technology support
  4. ADO.NET Entity Framework
  5. Extended data access technologies and functionality
  6. Business Intelligence Solutions Support
  7. WinForms-specific features
  8. ASP.NET-specific features
  9. Script execution
  10. SQL execution monitoring
  11. Design-time enhancements
  12. Product clarity
  13. Licensing and support

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


  • Full support of the latest versions of DB2
  • Full support for x64 architecture
  • Microsoft Visual Studio 2008, 2010, 2012, 2013, and 2015 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