dotConnect for DB2是一個(gè)支持ORM的增強(qiáng)型DB2數(shù)據(jù)提供程序，它基于ADO.NET技術(shù)和IBM DB2.NET Data Provider來提供用于開發(fā)基于DB2的數(shù)據(jù)庫應(yīng)用程序的完整解決方案。它允許用戶輕松地將DB2數(shù)據(jù)與廣泛使用的面向數(shù)據(jù)的技術(shù)集成，并在.NET應(yīng)用程序中使用它們。它提供更好的實(shí)體框架支持、ASP.NET項(xiàng)目的更多特性、本地SSIS源和目的地組件以及更多特性。

高級ADO.NET提供程序

dotConnect for DB2提供了許多創(chuàng)新的開發(fā)工具和技術(shù)，這些工具和技術(shù)在IBM DB2.NET Data Provider中不可用。它支持連接（DataTable）和斷開（DataSet）的數(shù)據(jù)訪問模型，提供高級組件，如DB2Script、強(qiáng)大的工具——DataSet Wizard和DataSetManager等。

實(shí)體框架

dotConnect for DB2為實(shí)體框架模型-實(shí)體開發(fā)者提供了增強(qiáng)的實(shí)體框架支持。dotConnect for DB2支持代碼優(yōu)先、模型優(yōu)先、數(shù)據(jù)庫優(yōu)先和混合開發(fā)方法、特定于DB2的類型和函數(shù)、存儲過程等。

ASP.NET支持

dotConnect for DB2為ASP.NET項(xiàng)目提供了許多特性。它提供了用于數(shù)據(jù)訪問的高級DB2DataSource組件和ASP.NET提供程序模型支持。它提供了諸如成員資格提供者和角色提供者（以及SimpleMembership提供者）、會話狀態(tài)提供者、站點(diǎn)地圖提供者、Web事件提供者和個(gè)性化提供者之類的ASP.NET提供者。

BIS支持

dotConnect for DB2為SQL Server Integration Services包中的數(shù)據(jù)流提供本機(jī)源和目的地組件。使用dotConnect for DB2輕松地從DB2數(shù)據(jù)庫導(dǎo)出和導(dǎo)入數(shù)據(jù)。dotConnect for DB2也可以用于Analysis Services和Reporting Services項(xiàng)目。

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, and 2012 support
• CodeGear RAD Studio 2007 support
• Embarcadero Delphi Prism support
• SQL Server 2008 and 2012 Business Intelligence Solutions 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
• 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 Develop

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

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

• ASP.NET data providers: Membership, Role, Session State, Profile, Personalization, Site Map, Web Event
• ASP.NET SimpleMembership providers support
• DB2DataSource web component

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

• Automatic component registration in toolbox
• Advanced integration with Visual Studio 2008, 2010, and 2012, including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder and configuring web component DB2DataSource
• DataSet Wizard to create and edit typed DB2-oriented datasets
• DataSet Manager to list and bind datasets in the project
• DataSet Editor to edit dataset contents
• Advanced design-time component and property editors
• IntelliSense descriptions for dotConnect for DB2 classes
• Syntax highlighting in design-time editors
• TableMappings editor
• Convenient instant data preview and management in design time

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