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

Active Query Builder News

April 29, 2016

Active Query Builder for .NET (WinForms and WPF) 3.1 is released.

We're glad to announce the new 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.

We've put a lot of efforts to make the new major version as fast and stable as possible. Of course, there are many nice features that we've announced but haven't finished yet. You can treat our promises as our to-do list for this year.

In the next minor version, we will add the new sidebar panel to replace all modal property dialogs.

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

  • The minimal version of .NET framework for WinForms edition is raised to 4.0.
  • User interface made with DevExpress controls is made for WinForms Edition. (available in Professional subscriptions only).
  • Chinese (Taiwan) translation is added.
  • The Flat view mode for the Database Schema Tree control is made. You can choose between the list view and tree view modes now. The new property QueryBuilder.DatabaseSchemaTreeOptions.ViewMode is added. Set it to Flat to turn the control into list view mode. The default value is Tree.
  • Query Navigation Bar: Reordering of unions and addition of existing CTEs or derived tables is possible with drag'n'drop now.
  • Query Navigation Bar gets scrolled in the case of a large list of unions or sub-queries; the new QueryNavigationBar.PopupMaxHeight property is made.
  • Recognition of date and string literals, and lists of literals in the IN clause is improved in Criteria columns. Items in parentheses after the IN keyword are quoted automatically now.
  • Definition of relationships between objects in the Metadata Container using alternate names is possible now.
    This allows you to add one object with different alternate names which are useful when it can be used in different roles. For example, if a table refers to itself holding information about child and parent items, you can add it to the Metadata Container twice with "child_items" and "parent_items" alternate names, then add a reference from child to parent. It'll be much easier for end-user to create a child-to-parent relationship in the query.
    The MetadataForeignKey.ReferencedObject property now accepts alternate names.
  • Query Statistics: New properties are added to the StatisticsOutputColumn class to ease determination of the origin of a column in case it comes from derived table or CTE: OriginDatasource, OriginMetadataObject and OriginMetadataField.
  • Data type computation in expressions has been made for Oracle.
  • Oracle: Database links support is made.
  • Sybase: Metadata retrieval from SAP IQ is possible now.
  • Several fixes and improvements for tooltips have been made.
  • The new demo projects are added for C# language (WinForms and WPF): Query Transformer demo, Query UI Events demo, Interface Customization demo, Datasource Fields Linking by Drag'n'Drop demo, Alternate Names demo, Drag'n'Drop demo, Custom Columns demo, Non-Visual demo, Load Metadata demo.
  • SQL Text Editor: Navigation with the Ctrl key and word wrapping are fixed.
  • Other bugfixes and improvements have been made.
» 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