Active Query Builder » News » Active Query Builder .NET Edition News
- April 04, 2020
-
Active Query Builder for .NET 3.6 helps find and change various options in the query faster.
We are glad to present to your attention the new version of Active Query Builder for .NET WinForms and WPF Editions. Using it you will deal with routine SQL tasks much faster.
The free evaluation version is instantly available for download on the download page. Customers can download the full version in the Customer's area.
What's new in version 3.6?
- Faster SQL building with new ways to navigate and edit queries
- The indication of sorting, aggregation, and conditions for a column in the object field list on Design Pane has been made.
- The new way to define sorting, grouping, aggregations, and sorting via the context menu of the datasource field list has been introduced. It also helps to switch to the existing condition in the Query Columns grid.
- It's possible now to define a set of ready-to-use conditions for specific fields and data types for instant applying via the datasource field list context menu.
- The user can switch now to sub-queries in WHERE and HAVING parts of the query using a button next to a corresponding field in the datasource field list.
- The indication of sorting, aggregation, and conditions for a column in the object field list on Design Pane has been made.
- Query Columns Grid improvements
- Inline suggestions:
- Expression column suggests fields from tables in the current sub-query, grouped by table.
- Logical operators are suggested in condition columns, "true" and "false" constants for boolean expressions like EXISTS sub-queries.
- Multiple rows operations
- The user can select multiple rows by mouse and reorder by dragging or delete/reorder them using keyboard shortcuts or the context menu.
- The user can insert an empty row by dragging the last blank row to an arbitrary position or using the context menu.
- The user can perform appropriate actions on columns by right-clicking on column headers (clear all sorting, etc.).
- Keyboard shortcuts
Alt+Arrow down Display drop-down list in appropriate columns Alt+Enter, Shift+F2 Open the multiline expression editor where it is possible Shift+Arrow up/down Multiple rows selection Ctrl+Arrow up/down Grid scrolling Ctrl+Alt+Arrow up/down Movement of selected columns up and down
- Inline suggestions:
- Other important improvements
- Support for the Right-to-left oriented layout has been made.
- Hebrew and Dutch localizations have been added; other localizations are updated.
- SQL Text Editor: On-demand metadata loading for suggestions has been improved.
- DevExpress controls UI: Full support of skins, including dark themes. All custom controls now obey skin colors.
- Query Transformer: The ability to add grouping (GROUP BY section) to the initial query has been made.
- The programmer now has full control over the context menus.
- Last, but not the least, the ability to consolidate metadata from different connections to use in one SQL query.
- Faster SQL building with new ways to navigate and edit queries
Comments by Disqus:
News
- 12/14/2023
Active Query Builder ASP.NET Edition 3.10 adds support for SignalR client-server communication
Support for SignalR lets use Active Query Builder in Blazor apps. - 09/20/2023
Active Query Builder VCL Edition 1.34 adds support for Snowflake and Firebird 4
New SQL Text editor API improvements and performance optimizations are made. - 04/11/2023
Active Query Builder VCL Edition 1.33 speeds up the SQL text editor
The new SQL filter builder control lets save user-defined filters between work sessions. - » Active Query Builder news
-
Subscribe
Testimonials
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!