Product Documentation

c-treeACE V10.0 Update Guide

Previous Topic

Next Topic

ADO.NET

  • c-treeACE SQL ADO.NET Entity Framework Support - The c-treeACE SQL ADO.NET Data Provider now has support for Entity Framework. When Visual Studio is detected during c-treeACE Professional installation, support is integrated by default.
  • Added support for IDENTITY columns to Entity Framework provider.
  • Added support for alternative Character Sets - The previous version had a hard-coded definition for the supported Character Set, which was fixed to iso-8859-1. This character set was good for English and Western European languages. A customer from Hungary complained that some language-specific characters were not properly handled so we decided to add a configurable character set.
  • Clob and Blob types - The Clob and Blob types are now fully supported.
  • c-treeACE SQL ADO.NET Data Provider Time Fields Now Map to .NET CLR TimeSpan Class - The c-treeACE SQL Time type (c-tree CT_TIME) was originally mapped to a .NET DateTime type based on the lack of a Time class in the .NET CLR and that a c-treeACE SQL Time value was best represented by a DateTime class due to the point-in-time nature of the pair. It was noted that Microsoft mapped ODBC Time types to TimeSpan in .NET and SQL Server 2008 introduced a Time type that also mapped to this class. c-treeACE SQL Time is now mapped to a .NET TimeSpan type to better align with the Microsoft chosen mapping. This is a compatibility change to be noted in migrating c-treeACE SQL ADO.NET Provider applications to c-treeACE SQL V9.3.
  • TINYINT type missing from EF schema - We now properly handle the TINIINT type in EF schema.
  • Added GetScale() method to CtreeSQLDatareader - It is often necessary to get the decimal fields scale value in order to properly format the fields. For this reason we added the new int GetScale(fieldindex) method to CtreeSQLDatareader class that returns the field scale.

TOCIndex