Active Query Builder for .NET 3.8 adds support for .NET 5.0 and makes visual query building a charm.
We are glad to present to your attention the new version of Active Query Builder for .NET WinForms, WPF, and ASP.NET Editions. Using it you will deal with routine SQL tasks much faster and help users get access to data.
Active Query Builder has got support for .Net 5.0.
User Interface Improvements
Four columns of the Query Columns List are merged into two for easier reading and changing the query column options. "Sort Order" and "Sort Type" became "Sorting"; "Grouping" and "Aggregate" are now "Group/Aggregate".
The way the user works with grouping and aggregation via the datasource field context menu on the Design Pane has been changed.
The user sees if multiple columns of the same field exist in the query, can explicitly add and remove them. The selection of a new aggregate function via the context menu doesn't add a new column to the query but changes the properties of the existing column.
When several foreign keys exist between a pair of database objects, their addition to the query leads to linking them only by one particular foreign key, not by all of them at a time.
The user can switch the foreign key of the link between such objects using the special button. It is displayed when the link is selected.
The component can automatically generate short aliases for newly added objects. Use the BehaviorOptions.GenerateShortObjectAliases property to turn it on and off.
The component can normalize object names found in the query according to the database schema or leave them untouched. The new SqlGenerationOptions.ObjectNamesNormalization property controls this behavior.
It is now possible to hide from the user (but not remove) unwanted objects and fields in the Metadata Container. Use the new property MetadataItem.Visible for this purpose.
The new bool property MetadataField.DisplayInLookup identifies fields suitable for record identification in lookup controls.
The new list property MetadataField.EnumValues lets ease the user selection of enum-coded values.
The new panel is added to the top-right corner of the Design Pane to show or hide unused fields for all objects in a single click.
The preview area in the left-bottom corner of Design Pane is hidden from the start and shown minimized when scroll bars are displayed.
The programmer can save and restore widths of columns set by the user via the new QueryBuilder.QueryColumnListControl.SaveLayout and RestoreLayout methods.
The programmer can save and restore the entire component layout, including side panels' docking position and columns' width in the Query Column List. Use the new QueryBuilder.SaveLayout and RestoreLayout methods.
Demos: Reports generation has been added to the Full-featured MDI demo for Stimulsoft, ActiveReports, and FastReport.
Demos: Export to Excel and CSV has been added to the Full-featured MDI demo.
Severe problems with disposing of the component before its complete initialization are fixed.
Thread-safe methods to initialize the component are added.
Demos: The new React demo illustrating the component's use in a SPA application backed with a microservice architecture is added.
Demos: The new scalable multi-container Redis-backed demo project with a custom state storage provider is made.
We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!
We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...
In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!