Changelog

January 19, 2021

Version 7.0.0-rc1 - EasyQuery Kernel packages

2021-01-18

  • [New]: Add PreserveFormatting in IDataExportSettings

  • [New]: Condition.Clone method

  • [New]: ReturnQueryStatementOnExecute option fpr middleware

  • [New]: GetQueryFileExt function in EasyQueryApiHandler

  • [New]: Sort enum by its names with special attribute for property - EqSortByEnumNames

  • [New]: SkipForeignKeys option in DbContextLoaderOptions

  • [New]: HideKeyFields parameter in DbConnectionLoaderOptions

  • [New]: Default list value editors for special dates and times

  • [New]: Hide method in EntityAttr

  • [New]: Custom linq operators

  • [New]: QueryTuner option

  • [New]: EqErrorResult implementation of ActionResult for Controller

  • [New]: Save query to file/ Load query from file functionality

  • [New]: Clien Extra Conditions support

  • [New]: DoNotPrettifyNames method in DbConnectionLoaderOptions

  • [New]: Lightweight result set format

  • [New]: Query.InnerData dynamic property
    This object allows to store some addtional information with each query. For example, save the list of facets in the result panel

  • [New]: FileQueryStoreSettings.FileFormat property.
    By default this the value of this property is "json" but you can also set to "xml"

  • [New]: HasSubQuery option in EntityAttr
    It's set to true when the attribute's expression contains a sub-query

  • [New]: Add custom tuner

  • [New]: AddFileExtensionsResolver to middleware options.
    This option allows to amend the file extension of the exporting data.

  • [New]: DeleteSubEntities() methods in Entity class.
    2 methods which allow to remove sub-entities of some entity based either on their names or some "filter" function.

  • [New]: Show() and Hide() method in Entity class
    These methods allow to hide or show some entity (turn off/on all UseIn... properties) with a one line of code

  • [New]: DisplayName property in EqEntityAttrAttribute

  • [New]: TableLink.SwitchDirection method
    This method allows to switch the direction of the link between two tables (Table1 -> Table2 becomes Table2 -> Table1)

  • [New]: Add Index property to EqEntityAttribute and EqEntityAttrAttribute

  • [Upd]: Chart setting for Razor pages. Use ResultFacetsPanel for AdhocReporting if JS Version is 6.1.x or higher

  • [Upd]: Add ShowDatasetInfo options to DataExportSettings. Add GetDefaultSettings to default exporters

  • [Upd]: Return querySaved on Sync

  • [Upd]: Refactor EasyQueryMiddleware with EasyQueryApiHandler

  • [Upd]: Suppot sorted columns in DynamicQuery

  • [Fix]: NullReference exception in case of "no path between 2 tables" situation

  • [Fix]: NullReference exception on queries with InJoin conditions

  • [Fix]: Support for views in EF Core 5.0

  • [Fix]: Support TPH in Entity Framework Core.

  • [Fix]: Ignored navigation properties were still added into the model

  • [Fix]: Processing sub-queries that have fields from the parent queries

  • [Fix]: Bug with adding expressions to group by from Virtual attributes and Custom Expressions when GroupByCalcColumns is turned off.

  • [Fix]: Incorrect processing of old macro values (like $) on XML loading

  • [Fix]: Error on loading XML queries with sub-queries

  • [Fix]: New queries were stored automatically if SaveQueryOnSync was turned on

  • [Fix]: Add Guid to quoted types

  • [Fix]: Do not hide UNIQUE fields with KEY fields for MsSqlServer when model is loaded from connection

  • [Fix]: Make EasyQueryManager IDisposible

  • [Fix]: DateTimeOffset was recognized as Int32 in SqlClientGate

  • [Fix]: Table category saving/loading to/from JSON

  • [Fix]: Value Editor wasn't saved together with default operand

  • [Fix]: Asynchronous saving/loading of InnerData and ExtraData in Query

  • [Fix]: Wrong behavior of TableStore.Add

  • [Fix]: UseInSorting parameter of Attribute processing on LoadFromEntityType

  • [Fix]: Check if Query not null before calling BuildQuery in EasyQueryManager

  • [Fix]: ExecuteQuery of EasyQueryManagerLinq. Add SortedColumns support

  • [Fix]: Save/Load Query.ExtraData to/from XML

  • [Fix]: GROUP BY cluase for columns with sub-queries

  • [Fix]: Table -> Aliases splitting mechanism on loading from a DbContext or DbConnection

  • [Fix]: TableLink.Enabled was not saved to the data model file

  • [Fix]: Table priority was not taken into account on constructing the path between tables

  • [Fix]: Saving editors in JSON

  • [Fix]: Saving file path on loading model from JSON file

Version 5.4.6 - EasyQuery Kernel packages

2021-01-19

  • [Fix]: Wrong processing of "formats" request parameter in EasyQueryManagerSql

  • [Fix]: "IsAggregate" was not set properly for Custom SQL expressions

  • [Fix]: NullReference exception in case of "no path between 2 tables" situation

  • [Fix]: NullReference exception on queries with InJoin conditions

Version 5.4.5 - EasyQuery Kernel packages

2021-01-09

  • [Upd]: Chart setting for Razor pages. Use ResultFacetsPanel for AdhocReporting if JS Version is 6.1.x or higher

  • [Fix]: Support for views in EF Core 5.0

Version 5.4.4 - EasyQuery Kernel packages

2020-12-01

  • [New]: Add PreserveFormatting in IDataExportSettings

  • [New]: Condition.Clone method

  • [Upd]: Add ShowDatasetInfo options to DataExportSettings. Add GetDefaultSettings to default exporters

  • [Fix]: Support TPH in Entity Framework Core.

  • [Fix]: Ignored navigation properties were still added into the model

  • [Fix]: Processing sub-queries that have fields from the parent queries

  • [Fix]: Bug with adding expressions to group by from Virtual attributes and Custom Expressions when GroupByCalcColumns is turned off.

  • [Fix]: Incorrect processing of old macro values (like $) on XML loading

  • [Fix]: Error on loading XML queries with sub-queries

Version 5.4.4 - EasyQuery .NET Framework packages

2020-12-02

  • [Fix]: Drag-n-drop processing for LookupAttr attributes

  • [Fix]: EntitiesPanel shows both attributes lined with LookupAttr

  • [Fix]: Duplicate operation now creates new condition right after the original one

Version 5.4.3 - EasyQuery Kernel packages

2020-10-23

  • [New]: ReturnQueryStatementOnExecute option fpr middleware

  • [Fix]: New queries were stored automatically if SaveQueryOnSync was turned on

  • [Fix]: Add Guid to quoted types

  • [Fix]: Do not hide UNIQUE fields with KEY fields for MsSqlServer when model is loaded from connection

Version 5.4.3 - EasyQuery .NET Framework packages

2020-10-26
  • [New]: ReturnQueryStatementOnExecute option processing

Version 5.4.2 - EasyQuery .NET Framework packages

2020-09-30

Version 5.4.2 - EasyQuery Kernel packages

2020-09-30

  • [New]: GetQueryFileExt function in EasyQueryApiHandler

  • [New]: Sort enum by its names with special attribute for property - EqSortByEnumNames

  • [Fix]: Make EasyQueryManager IDisposible

  • [Fix]: DateTimeOffset was recognized as Int32 in SqlClientGate

  • [Fix]: Table category saving/loading to/from JSON

Version 5.4.1 - EasyQuery .NET Framework packages

2020-09-11

  • [Upd]: Return querySaved on Sync

  • [Fix]: Return meta on executeQuery

Version 5.4.1 - EasyQuery Kernel packages

2020-09-11

  • [New]: SkipForeignKeys option in DbContextLoaderOptions

  • [New]: HideKeyFields parameter in DbConnectionLoaderOptions

  • [New]: Default list value editors for special dates and times

  • [New]: Hide method in EntityAttr

  • [New]: Custom linq operators

  • [New]: QueryTuner option

  • [Upd]: Return querySaved on Sync

  • [Fix]: Value Editor wasn't saved together with default operand

  • [Fix]: Asynchronous saving/loading of InnerData and ExtraData in Query

  • [Fix]: Wrong behavior of TableStore.Add

  • [Fix]: UseInSorting parameter of Attribute processing on LoadFromEntityType

  • [Fix]: Check if Query not null before calling BuildQuery in EasyQueryManager

Version 5.4.0 - EasyQuery .NET Framework packages

2020-08-17

  • [New]: Save query to file/ Load query from file functionality

  • [New]: GetFileExtentionByContentType virtual method.
    This method allows to override the default behavior of getting the extension of the exported file by the content type.

  • [New]: Index property in EqEntityAttribute and EqEntityAttrAttribute

  • [New]: Saving Model DbParameters locally in DME

  • [New]: Error processing in EasyQueryApiController

  • [Fix]: Table -> Aliases splitting mechanism on loading from a DbContext or DbConnection

  • [Fix]: Remove BOM from the response content created by EasyQuery actions result classes

  • [Fix]: Checking connection string before checking db connection in DME

  • [Fix]: Save model loaded from JSON file in DME

  • [Fix]: Process ExtraParams in EasyQueryApiController.

Version 5.4.0 - EasyQuery Kernel packages

2020-08-18

  • [New]: EqErrorResult implementation of ActionResult for Controller

  • [New]: Save query to file/ Load query from file functionality

  • [New]: Clien Extra Conditions support

  • [New]: DoNotPrettifyNames method in DbConnectionLoaderOptions

  • [New]: Lightweight result set format

  • [New]: Query.InnerData dynamic property
    This object allows to store some addtional information with each query. For example, save the list of facets in the result panel

  • [New]: FileQueryStoreSettings.FileFormat property.
    By default this the value of this property is "json" but you can also set to "xml"

  • [New]: HasSubQuery option in EntityAttr
    It's set to true when the attribute's expression contains a sub-query

  • [New]: Add custom tuner

  • [New]: AddFileExtensionsResolver to middleware options.
    This option allows to amend the file extension of the exporting data.

  • [New]: DeleteSubEntities() methods in Entity class.
    2 methods which allow to remove sub-entities of some entity based either on their names or some "filter" function.

  • [New]: Show() and Hide() method in Entity class
    These methods allow to hide or show some entity (turn off/on all UseIn... properties) with a one line of code

  • [New]: DisplayName property in EqEntityAttrAttribute

  • [New]: TableLink.SwitchDirection method
    This method allows to switch the direction of the link between two tables (Table1 -> Table2 becomes Table2 -> Table1)

  • [New]: Add Index property to EqEntityAttribute and EqEntityAttrAttribute

  • [Upd]: Refactor EasyQueryMiddleware with EasyQueryApiHandler

  • [Upd]: Suppot sorted columns in DynamicQuery

  • [Fix]: ExecuteQuery of EasyQueryManagerLinq. Add SortedColumns support

  • [Fix]: Save/Load Query.ExtraData to/from XML

  • [Fix]: GROUP BY cluase for columns with sub-queries

  • [Fix]: Table -> Aliases splitting mechanism on loading from a DbContext or DbConnection

  • [Fix]: TableLink.Enabled was not saved to the data model file

  • [Fix]: Table priority was not taken into account on constructing the path between tables

  • [Fix]: Saving editors in JSON

  • [Fix]: Saving file path on loading model from JSON file

Version 5.3.7 - EasyQuery Kernel packages

2020-04-26

  • [New]: DataExportTuner interface
    This interface allows you to tune export settings

  • [New]: ExtraParams property in ListValueEditor

  • [Upd]: Updated the registration of CustomValueListResolver.
    Notice. Old AddValueListResolver method of EasyQueryOptions is deprecated now. Use a new one.

Version 5.3.6 - EasyQuery .NET Framework packages

2020-04-10

  • [Fix]: Name prettifier on model load

  • [Fix]: Problem with macro processing date in WinForms

Version 5.3.6 of EasyQuery kernel packages

2020-04-09

  • [Fix]: Wrong SQL when there is a group with all disabled conditions

  • [Fix]: Name prettifier on model loading from a DbConnection

  • [Fix]: Problem with SelectDistinct when LegacyPaging is true
    Now SqlQueryBuilder uses DENSE_RANK() function instead of ROW_NUMBER() when SelectDistinct is true

  • [Fix]: Formatting when value contains new line symbol

  • [Fix]: Ignore RowNumber column on export
    RowNumber column for legacy page was not ignored on export

Version 5.3.5 of EasyQuery kernel packages

2020-03-30

  • [New]: Formats.JoinsOrder propery in SqlQueryBuilder
    Allows to define the order of table joins in the FROM clause of generated SQL

  • [New]: LegacyPaging option for DbQueryFormats
    Enables paging which uses ROW_NUMBER() function.

  • [New]: UseCustomFuncInOrderBy option for DbEntityAttr
    If the option is set to false, CustomFunc of the EntityAttr will not be added to order by expression.

  • [Fix]: Wrong format of JSON file on saving via FileQueryStore
    If size of the target file is bigger than the size of the saved content - we got wrong JSON in result.

  • [Fix]: Paging support for Oracle
    Paging was not turned on by default for FormatType.Oracle format type. Now it's properly supported the similar way as for SQL Server

Version 5.3.4

2020-03-06

  • [New]: ReturnQueryOnSave option for EasyQueryMiddleware option.

  • [Fix]: CustomFunc is processed before applying the aggregate functions in columns.