DataCollection

Bug fixes

• Fixed the issue where the CurrentPage of C1PagedDataCollection was not updated correctly when the source was filtered.
• [AdoNet] Fixed problems when connecting to SQLServer in C1AdoNetVirtualDataCollection and C1AdoNetCursorDataCollection.

Improvements

• Added editing support in C1AdoNetVirtualDataCollection.

Data Connector

Bug Fixes

• Fixed the issue where the number of data returned was incorrect when the query contained both 'DISTINCT' and 'LIMIT'.
• Fixed the issue where the error occurred on executing union all or union query. 
• Fixed a bug related to licensing for publish single file.

Improvements

• Removed nullable in the ConnectionStringBuilder's properties.
• Supports DataReader's GetSchemaTable().

C1.AdoNet.D365S

Improvements

• Removed nullable in the ConnectionStringBuilder's properties.
• Added display name to the ConnectionStringBuilder's properties. Supports DbFactory.

C1.AdoNet.GoogleAnalytics

Bug fixes

• Fixed the issue columnName in datareader different between cache and no cache.

Improvements

• Removed nullable in the ConnectionStringBuilder's properties.
• Supports DataReader's GetSchemaTable().
• Supports DbFactory.
• Added display name to the ConnectionStringBuilder's properties.
• Removed the checking open connection before create a command.

C1.AdoNet.Kintone

Bug fixes

• Fixed the issue where an error occurred when executing the query containing 'compare text column' with null or not null.
• Removed nullable in the ConnectionStringBuilder's properties.
• Fixed the issue where the columnName in datareader was different in 'cache' and 'no cache'.

Improvements

• Changed output datatype of Time column to TimeSpan.
• Updated DateTime behavior.
• Supports DataReader's GetSchemaTable().
• Supports DbFactory.
• Removed redundant property in ColumnSchema.
• Added display name to the ConnectionStringBuilder's properties.

Improvements

• Removed the checking open connection before create a command.

C1.AdoNet.OData

Bug fixes

• Fixed the issue where a selected column's nested complex type.
• Fixed the issue where the execute join query failed when the support was false.
• Fixed the issue where the Insert DateTimeOffset column failed when using DbParameter.
• Fixed the issue where the selection failed with query containing left join and order by.
• Fixed the issue where the correct column name when the GetSchematable has a column complex type.
• Fixed the issue where the columnName in datareader was different in 'cache' and 'no cache'.

Improvements

• Removed nullable in the ConnectionStringBuilder's properties.
• Updated DateTime behavior.
• Supports DataReader's GetSchemaTable().
• Supports DbFactory.
• Added display name to the ConnectionStringBuilder's properties.
• Removed the checking open connection before create a command.

C1.AdoNet.QuickBooksOnline

Bug fixes

• Fixed the issue where the columnName in datareader was different in 'cache' and 'no cache'.

Improvements

• Removed nullable in the ConnectionStringBuilder's properties.
• Updated DateTime behavior.
• Supports DataReader's GetSchemaTable().
• Supports DbFactory.
• Added display name to the ConnectionStringBuilder's properties.
• Removed the checking open connection before create a command.

C1.AdoNet.Salesforce

Bug fixes

• Fixed the issue where the columnName in datareader was different in 'cache' and 'no cache'.

Improvements

• Changed the output datatype of Time column to TimeSpan.
• Removed nullable in the ConnectionStringBuilder's properties.
• Updated DateTime behavior.
• Supports DataReader's GetSchemaTable().
• Supports DbFactory.
• Added display name to the ConnectionStringBuilder's properties.
• Removed the checking open connection before create a command.

C1.EntityFrameworkCore.D365S

Improvements

• Supports EFCore 3.1.

C1.EntityFrameworkCore.GoogleAnalytics

Improvements

• Support EFCore 3.1.

C1.EntityFrameworkCore.Kintone

Improvements

• Supports EFCore 3.1.

C1.EntityFrameworkCore.OData

Improvements

• Supports EFCore 3.1.

C1.EntityFrameworkCore.QuickBooksOnline

Improvements

• Supports EFCore 3.1.

C1.EntityFrameworkCore.Salesforce

Improvements

• Supports EFCore 3.1.

DataEngine

Bug Fixes

• Fixed the exception when binding to TimeSpan type using C1FlexPivot.
• Fixed the issue where there were incorrect results with alphabetic grouping when bound to DataEngine.
• Fixed the issue where the user could not edit FlexPivotPanel after alphabetic grouping applied.
• Fixed the issue where the FlexPivotGrid could not be filtered by slicer when '% of grand total' was applied.
• Fixed the issue where there was incorrect count when a column had both empty strings and DBNull values.
• Fixed the issue where the details for rollup columns was not correctly applying filters.
• Fixed the issue where there were incorrect aggregation results when null values were present.
• Fixed the issue where there were Incorrect aggregation results with multiple value fields and grouped rows.
• Corrected formatting of DateTime values in DataList.Write methods.

Improvements

• Added support for netcoreapp3.0 version of AdomdClient package (preview).
• [Workbench] Added CSV/JSON export feature.
• [Workbench] Support Categories/Values properties in grid views.