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

August 20, 2018

Active Query Builder for .NET 3.5 makes the everyday work with SQL queries more comfortable.

We are glad to present to your attention the new version of the AQB for .NET WinForms and WPF Editions. In it, we’ve put lots of effort to make the component integration smooth and the end user's everyday work comfortable.

The free evaluation version is instantly available for download on the download page. Customers can download the full version in the Customer's area.

Query Building interface

Not noticeable at first glance, but significant refinements for the everyday work with SQL queries have been made:

  1. The ability to mark database objects as favourites lets find the most frequently used objects faster. *
  2. Displaying details about the selected database object helps get the information about data structure faster. *
  3. Code completion in the Expression and Criteria cells allows writing SQL expressions easier. *
  4. Identifying and correcting errors in SQL expressions is now easier with smart notifications.
  5. The prompt for sub-query deletion doesn’t block the user interface now making the query building process smoother.

Items marked with an asterisk (*) are available in the Professional version only.

Ease of integration

We've revised all of the auxiliary controls and the intermediate code between Active Query Builder and your software making the integration into your application as quick and straightforward as possible.

  • Serialization of all component properties.
  • Methods for easy previewing of the sub-query result data.
  • The completely re-designed Metadata Container editor is now much more enjoyable for configuring metadata and its presentation in the Database Schema View.

A large part of the new features is based on the ability to use parts of the component’s UI apart from the component itself, which is available in the Professional version only. These options make the Professional version a real time-saver providing the best experience for the programmers.

  • Controls to edit the component properties.
  • Controls to edit properties of supported .NET DB connection libraries.
  • Metadata Loading Wizard to let users load metadata from a database in a few simple steps.
  • Metadata Filter editor control.

Parts of the demo projects can be copied straight to your project to allow for the lightning-fast integration:

  • Ready-to-use form to choose the DB connection library, edit their properties and connect.
  • Ready-to-use form to edit all of the component properties.
  • SQL formatting options editing form with pre-defined formatting schemes and code preview.
  • The sample form to allow even casual users to filter out unwanted objects and namespaces in a few clicks.

(See the screenshots gallery below)

We also conducted a review of all component resources, both textual and graphic, simplified the work with them: it is now possible instantly change a string or icon in the component UI in run-time with a single command.

The new Japanese localization is made, eight localizations are updated and proofread by professionals: German, French, Spanish, Portuguese (Brazil), Chinese (Traditional), Italian, Turkish, and Russian.

Other changes

  • Support for SAP HANA and Pervasive (Actian Zen) have been added.
  • The new DatabaseSchemaTree.DefaultExpandMetadataType property allows expanding the tree not to the specified number of levels but up to the specified metadata type (for example, up to schemas or objects). It supersedes the DefaultExpandLevel property.
  • The Simple Metadata Filter now accepts full-qualified names in the Schemas and Objects collections making possible to filter out specific objects rather than "unwanted names".
  • Checkboxes in data sources on the Design Pane can be hidden now by setting the DataSourceOptions.CheckboxesVisible property to false.
  • Expressions in the Expression Editor are formatted now according to the settings assigned to the ExpressionEditor.SQLFormattingOptions property.

Reference for the new properties and methods can be found in the Release notes article on the Support Portal.

Screenshots gallery

Component Properties editing forms:

Connection Properties editing forms:

at ActiveDBSoft.
» All Active Query Builder news

Comments by Disqus:




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!

Social networks

1) Warning: Use of uninitialized value $Apache::Scriptor::Handlers::section in string ne at _left-col.html line 2, <F> chunk 1.
2) Warning: Use of uninitialized value $Apache::Scriptor::Handlers::section in string ne at _left-col.html line 36, <F> chunk 1.