# 2021 v1

## Content



## 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.