Active Query Builder  »  News  »  Active Query Builder .NET Edition News

Active Query Builder News

October 27, 2016

Active Query Builder for .NET 3.2 improves the user experience with the new docked side panels.

We're glad to announce the new minor version of Active Query Builder 3 for .NET WinForms and WPF Editions. You can evaluate the new version by requesting the trial. Customers can download the new version in the Customer's area.

Feel free to leave your feedback in the comments below this news story!

What's new in the Active Query Builder for .NET version 3.2 since version 3.1?

  • The pop-up window of the Query Navigation Bar displaying the structure of sub-query has been reorganized into a new control: the Sub-query Navigation Bar. Usability of this control has been improved: now you can change the order of union sub-queries using drag'n'drop and manage common table expressions much easier.
  • The new Properties Bar allows you to set various query, datasource and link properties without the need to open a dialog window. Such query properties as DISTINCT, LIMIT or TOP can now be defined in no time. Changing the join from inner to outer is now as easy as clicking on a radio button.
  • The QueryBuilder has got the new controls as dockable panels located to the left or right of the Design Pane. Users can adjust their size and position; settings can be saved between work sessions. All properties are now in front of the user. He (she) can hide the sidebars if he need not work with them right now.
  • The owners of Professional subscriptions can benefit from the new Dock Manager control. It lets hold any controls to the left, right or beneath its workspace. In the separate controls mode, you can place the Query Column List control in the bottom dock panel. The user can pin it when he (she) needs to work with query columns or hide it to give more space for the Design Pane. You can place the SQL Text Editor, or the Database Schema Tree into a dock panel, or you may not using the Dock Manager at your discretion. Have a look at the updated full-featured demo project to find a sample of using Dock Manager.
  • The Query, Datasource, and Link Properties dialogs are redesigned.
  • Ability to rename result query columns and get rid of duplicated column names has been added to the QueryTransformer.
  • Localization in the separate controls mode has been fixed.
  • Lots of optimizations and bug fixes have been made.

You can read full release notes in this article: "Active Query Builder for .NET 3.2 release notes".

The upcoming update to this minor version will add some missing strings to the localization and introduce some minor improvements for the Sub-query Navigation Bar.

In the next minor version, we will continue our efforts to improve the component's visual user interface.

» All Active Query Builder news

Comments by Disqus:

News

Tweets

Screenshots

Join Types

Automatic Joins Creation
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.

Different Join Types
Active Query Builder allows to define different join types and various server-specific query options visually.

Unions and Sub-queries

Unions and Sub-Queries
Unions, sub queries and derived tables can be accessed and built visually in Active Query Builder as easy as the main query.

Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.


Active Query Builder Screenshots

Social networks