Database specific features for IBM DB2

This section illustrates the database specific features for IBM DB2 which are available to you through configuration, either through the .config file of your application or through code.

See the Application configuration through .config files section for the details about the configuration settings defined through .config files.

See the RuntimeConfiguration system section for details about configuring the settings through code.

Temporal table support

For DB2, temporal tables are supported on DB2 10 or higher, for select / fetch queries using Linq or QuerySpec. Both Business Time and System Time predicates are supported. Below is an example using a linq query, where an entity is filtered using the System Time.

var q = metaData.Policy
                    .ForSystemTime("FROM {0} TO {1}", 
                                        new DateTime(2010, 1, 1), 
                                        new DateTime(2017, 1, 1))
                    .Where(p=>p.Vin == "A1111")
                    .Count();