The new major version of Active Query Builder for WinForms environment (.NET Edition) is finally released.
What's new in Active Query Builder 2 .NET Edition?
Changes in the API and behavior:
QueryBuilder properties are reorganized into several options groups.
Metadata Container is completely reworked to eliminate the need for metadata pre-loading. All the necessary information about database structure is loaded on demand now. Container is capable to store all possible types of artefacts, such as linked servers, packages, custom aggregates, etc.
Metadata Structure object is made to abstract from the physical structure of the database when displaying objects in the Database Schema Tree. Now it's possible to re-organize the Database Object's Tree the way you like.
The new Metadata Container and Structure editor allows you to setup the database objects representation for the end-user the way you like.
The list of used database objects and fields (QueryStatistics) can be obtained now for most of the query objects: sub-queries, datasources, query column list expressions.
The Configuration Wizard is made to configure Active Query Builder properties, database connection and accompanying components in a few simple steps.
The last but not the least: the property reference is avaialble for most parts of the component.
Visual changes:
Hiding the Sub-query Tabs above the Design Pane is possible now.
The Database Schema Tree is capable to display database object fields now.
The Add Object Form lets search for database objects.
Now it's possible to hide the Design Pane and build queries without it.
Swapping the Query Structure Tree and the Database Schema Tree with each other is possible now.
Learn more about changes in the new major version:
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!