Version 7.0.0-rc1 - EasyQuery Kernel packages
[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. AddGetDefaultSettings
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
[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
[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
[New]: Add PreserveFormatting in IDataExportSettings
[New]: Condition.Clone method
[Upd]: Add
ShowDatasetInfo
options to DataExportSettings. AddGetDefaultSettings
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
[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
[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
- [New]: ReturnQueryStatementOnExecute option processing
Version 5.4.2 - EasyQuery .NET Framework packages
Version 5.4.2 - EasyQuery Kernel packages
[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
[Upd]: Return querySaved on Sync
[Fix]: Return meta on executeQuery
Version 5.4.1 - EasyQuery Kernel packages
[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
[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
[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
[New]: DataExportTuner interface
This interface allows you to tune export settings[New]: ExtraParams property in ListValueEditor
[Upd]: Updated the registration of CustomValueListResolver.
Notice. OldAddValueListResolver
method ofEasyQueryOptions
is deprecated now. Use a new one.
Version 5.3.6 - EasyQuery .NET Framework packages
[Fix]: Name prettifier on model load
[Fix]: Problem with macro processing date in WinForms
Version 5.3.6 of EasyQuery kernel packages
[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
[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
[New]:
ReturnQueryOnSave
option for EasyQueryMiddleware option.[Fix]:
CustomFunc
is processed before applying the aggregate functions in columns.