Released: Dec 8, 2021

Updates in 2021 v3

Features

• New JSON DataConnector
  The JSON ADO.NET and EntityFramework DataConnector are now ready for production use. With this release, apart from reading JSON data, the data connector supports creating, updating, and deleting these functions and should be used in combination with a configuration file that defines the structure of data. In addition, the data connector is integrated with Visual Studio, which enables you to connect to JSON web service through Visual Studio Server Explorer, view JSON tables, and create queries using SQL or query builder. Drag-and-drop the JSON tables onto the dataset designer to add tables to the dataset and bind controls without writing a single line of code.
• Special Time Series Functions
  ComponentOne DataEngine now supports several useful time series functions:
  • Ytd (year-to-date).
  • Mtd (month-to-date).
  • Qtd (quarter-to-date).
  • Wtd (week-to-date).
  These functions are useful in business calculations where period-to-date, time-based summaries need to be created. For example, the Qtd function could be used to generate the financial statement from the start of the quarter to a specific date. The functions can be applied to a range or filter expressions.
• Make Your UI more "Data Aware" with the DataEngineCollection
  ComponentOne DataEngine simplifies data operations between data-aware controls like a DataGridView and a DataEngine query. By binding to the query using the new C1DataEngineCollection, users can sort grid data by clicking on the column header, or filter the data as the user types a filter text in a textbox.