dotConnect for DB2 History

This page lists the functionality added in each version of dotConnect for DB2. To view the full changelog including bug fixes, consult the dotConnect for DB2 revision history.


New features in dotConnect for DB2 2.1

The current build is 2.1.111 from 22-Sep-2016

  • Microsoft SQL Server Data Tools Business Intelligence (SSDT-BI) project templates for Analysis Services, Reporting Services, and Integration Services (mapping wizards) in Visual Studio 2015 are supported
  • Microsoft SQL Server 2016 is supported in SSIS DataFlow components
Entity Developer

  • Entity Framework Core 1.0 RTM is supported
  • The possibility to set values of stored procedure parameters for getting metadata to generate automatically the corresponding complex type is implemented
  • The behaviour is changed: the ObservableCollection navigation properties are initialized now in a default class constructor

Entity Framework

  • Entity Framework Core 1.0.1 is supported
  • The DB2ConventionSetBuilder class is implemented in the Entity Framework Core support
  • DB2CSharpMigrationCodeGenerator and DB2VisualBasicMigrationCodeGenerator for code-based migrations are implemented for EF4, EF5, EF6
  • The DatabaseFacade.GetDB2Connection() extension method, which returns DB2Connection, is implemented in EF Core
  • The new optional parameter Action<DB2DbContextOptionsBuilder> is added to UseDB2() extension method of DbContextOptionsBuilder in EF Core

New features in dotConnect for DB2 2.0

The current build is 2.1.111 from 22-Sep-2016

  • The Run Once Command connection string parameter, which specifies a command to execute when the connection is opened the first time and not executed when the connection is taken from the pool, is added
  • The new LoadTable overloads for loading data from a IDataReader, array of rows, or only rows with a specific RowState from a DataTable are added to the DB2Loader class
  • Truncate member that represents the TRUNCATE TABLE statement is added to the SqlStatementType enum

Entity Developer

  • Entity Framework Core support is added
  • The DbProviderFactory provider registration in application's *.config is supported by the Entity Developer version integrated into Visual Studio

Entity Framework

  • Entity Framework Core RC2 is supported
  • Entity Framework-related assemblies are renamed
  • Upgrade Wizard is improved for upgrading projects with the Entity Framework functionality

New features in dotConnect for DB2 1.8

  • Visual Studio 2015 is supported

Entity Developer

  • The Use ObservableCollection property of the DbContext template is implemented

New features in dotConnect for DB2 1.7

  • Visual Studio 2015 Release Candidate is supported
  • The ADO.NET implementation of ASP.NET Identity support is added

    • The ICloneable interface is implemented in the IdentityUser and IdentityRole classes
    • The User_Id column in the AspNetUserClaims table is renamed to UserId
  • The ADO.NET implementation of ASP.NET Identity 2.0 support is added

    • The new \Web\ASP.NET Identity 2\Devart.Data.DB2.Web.Identity.dll assembly (its revision number is 2) is added to the provider installation folder
    • The new \Web\ASP.NET Identity 2\Install_identity_tables.sql and \Web\ASP.NET Identity 2\Uninstall_identity_tables.sql files are added to the provider installation folder
    • The new \Web\ASP.NET Identity 2\Upgrade_identity_tables_from_v1_to_v2.sql file is added to the provider installation folder
    • The new IUserEmailStore<TIdentityUser, TKey>, IUserPhoneNumberStore<TIdentityUser, TKey>, IUserTwoFactorStore<TIdentityUser, TKey>, IUserLockoutStore<TIdentityUser, TKey> interfaces are implemented in the UserStore class
    • The new IUserStore<T>, IUserClaimStore<T>, IUserLoginStore<T>, IUserPasswordStore<T>, IUserRoleStore<T>, IUserEmailStore<T>, IUserPhoneNumberStore<T> interfaces are implemented in the DB2UserStore and DB2UserStore<TIdentityUser, TIdentityRole> classes
    • The new IRoleStore<T> interface is supported in the DB2RoleStore and DB2RoleStore<TIdentityUser, TIdentityRole> classes
    • The new IQueryableUserStore interface is implemented in the UserStore class
    • The new IQueryableRoleStore interface is implemented in the RoleStore class
  • The DB2Script.Cancel() method is added to stop query execution
  • The Enterprise Library 6 support is added; all previous versions of Enterprise Library are no longer maintained
  • The new \Web\ASP.NET 45\Devart.Data.DB2.Web.dll assembly (its revision number is 5) is added to the provider installation folder to support SimpleMembership in MVC5
  • The enableExpiredSessionAutoDeletion and expiredSessionAutoDeletionInterval options for deleting expired sessions are added to the session-state store provider definition in the web.config file
  • Microsoft SQL Server Data Tools Business Intelligence (SSDT-BI) project templates for Analysis Services and Integration Services in Visual Studio 2013 are supported
  • SSIS DataFlow Source and Destination components are supported in SSDT-BI for Visual Studio 2013
  • The behaviour is changed: the DB2Monitor now hides information about the password connection string parameter

Entity Developer

  • The information message about availability of NuGet Package Manager on the workstation is added in the Entity Developer version integrated into Visual Studio
  • The override modifier for DbSet class properties generated by DbContext templates is added
  • The View Generation option of the model with Entity Framework version = Entity Framework 6 is supported for the DbContext (only with XML mapping), EntityObject, POCO, and Self-Tracking Entities templates
  • The Implement Equals property is added to the DbContext, ObjectContext, and POCO Entity templates
  • The possibility to use relative paths to assemblies in code generation templates is implemented
  • The Remove Invalid Characters option (by default, True) is added to the Model Naming rules; if it is set to False, all invalid characters will be replaced with underscores
  • The Enable WinForms Data Binding property of the DbContext template is implemented
  • The Property Change Partial Methods property of the DbContext template is implemented for generating partial methods On%PropertyName%Changing and On%PropertyName%Changed for each primitive property of entity classes
  • The behaviour is changed: now partial configuration classes are generated when DbContext template is used with Fluent Mapping=True and Mapping Generation Strategy=UseConfigurationClasses options
  • The behaviour is changed: now paths to assemblies with attributes (Model Settings -> Model -> Attributes) are saved and used as relative paths
  • The behaviour is changed: now a property in the generated code is initialized basing on the default value in CSDL only (instead of default values in any of SSDL and CSDL)
  • The behaviour is changed: now the default value for the 'File Per Class' option of the DbContext template is True
  • The behaviour is changed: Generate Database Script From Model saves the output in ASCII format if there are no unicode symbols in the script; UTF-8 is used otherwise
  • The behaviour is changed: now the default values are not set for string properties, that correspond to fields with the default values like expressions

Entity Framework

  • Entity Framework 6.1.0 RTM is supported
  • Entity Framework 6.1.0 Tools for Visual Studio 2012 & 2013 are supported
  • The UpdateDatabaseOperation operation in Code-First Migrations for Entity Framework 6.x is supported
  • The RenameIndexOperation operation in Code-First Migrations for Entity Framework 6.1 is supported
  • Multiple EntityContainers in the Code-First CreateDatabase()/CreateDatabaseScript()/DeleteDatabase() functionality are supported
  • The Database.Delete(DbConnection) functionality is supported: all objects in the current schema (specified in Current Schema or set with Initialization Command connection string parameter) are removed if DatabaseScript.Schema.DeleteDatabaseBehaviour = AllSchemaObjects
  • The Database.Exists(DbConnection) functionality is supported: the method returns true if DatabaseScript.Schema.DeleteDatabaseBehaviour = AllSchemaObjects and at least one table exists in the current schema (specified in Current Schema or set with Initialization Command connection string parameter)
  • The database server version is added to the generated Code-First Migrations script
  • The releasing of memory, which was allocated for commands and readers of ObjectContext / DbContext, is improved
  • Determining correct datatypes of data retrieved by EntitySQL queries with UNION ALL and similar constructions is improved
  • The compatibility with Hibernating Rhinos EntityFramework Profiler is improved
  • The performance of generating SQL for Enumerable.Contains in LINQ queries is improved by supporting a new expression type, DbInExpression, in Entity Framework 6
  • The behaviour is changed: now a semicolon (;) after the very last statement is generated in the Code-First CreateDatabaseScript() functionality

31-October-13 New features in dotConnect for DB2 1.6

  • Visual Studio 2013 is supported
  • The behaviour is changed: installation with the /VERYSILENT install parameter will uninstall the other version of the provider without any dialog box if it is installed

Entity Developer

  • Entity Framework 6 is supported
  • The new "Provider Manifest Token" model property is implemented to identify the target server
  • The "WCF DataMember Attribute on Navigation Properties" property is added to the Data Transfer Object template for pointing the end (-s) where the attribute should be generated
  • More information messages, when validating EF6 models basing on the EntityFramework.dll functionality, are added
  • The behaviour is changed: the values of "Target Server" and "Server Version" can be reset via the Model Settings > Synchronization > Mapping dialog despite the fact whether connection is specified in Database Explorer or not
  • The behaviour is changed: the validation of EF6 models depends on the EntityFramework.dll functionality only (.NET Framework 4.5 is not required any more)

Entity Framework

  • The 6.0.0 and 6.0.1 versions of Entity Framework are supported
  • The DB2 for Linux/Unix servers are supported in Entity Data Model Wizard and Code-First functionality
  • The compatibility of Entity Framework provider for EF v1, v4, v5 with medium trust level environment is improved
  • The generation of SQL literals for TimeSpan values is improved: shortened form is used now if possible
  • The behaviour is changed: Entity Data Model Wizard shows a more detailed error message in case of connecting to unsupported database or using incorrect provider manifest tokens
  • The behaviour is changed: Code-First Migrations generates DEFAULT values for new NOT NULL columns of Boolean, DateTime, TimeSpan types when adding them in the existing table

17-October-13 New features in dotConnect for DB2 1.5

  • Microsoft Sync Framework support is implemented

Entity Framework

  • The behaviour is changed: Code-First Migrations generates DEFAULT 0 for new NOT NULL columns of numeric types when adding them in the existing table
  • The behaviour is changed: Code-First Migrations generates DEFAULT '' for new NOT NULL columns of string types when adding them in the existing table

08-August-13 First release of dotConnect for DB2 data provider