Active Query Builder 2 .NET Edition 2.9 is released.
We're glad to announce the new version of Active Query Builder 2 .NET Edition. You can evaluate the new version by requesting the trial. Customers can download the new version in the Customer's area.
What's new in the Active Query Builder .NET Edition version 2.9?
Major improvements:
Ability to save queries as persistent reusable objects for using as views in the following queries is added to the Professional .NET Subcription. Read more about the Reusable Queries in the Knowledge Book.
Use the PanesConfigurationOptions.UserQueriesPaneVisible property to show/hide the new "Reusable Queries" snippet.
To save and load user queries, use import/export methods of the QueryBuilder.UserQueries object.
Advanced Expression Editor, SQL Text Editor and Criteria Builder controls are skinned correctly with the DevExpress controls UI in Professional .NET Subcription.
Database Schema Tree performance is improved.
Minor improvements and API changes:
The new MetadataItem.UserData property is added to allow storing custom data for any metadata object.
The Linked Objects menu now shows "No linked objects" item if no linked objects were found.
It is now possible to set different color for focused links using the QueryBuilder.DesignPaneOptions.LinkStyle.LinkColorFocused property.
Query Transformer now supports Skip() with ROW_NUMBER ranking function for DB2 and MS SQL Server 2005-2008.
MS Access: Query Transformer is able to use Limit() with MS Access now.
The Show Query By Parts demo is replaced with the improved SubQuery Results Preview demo.
The DevExpress Demo source code sample project is added for C# and VB.NET.
SQL syntax improvements and changes:
Oracle: Support for SEARCH and CYCLE clauses in CTE subqueries is made.
RedShift: Loading of metadata using PostgreSQL syntax provider is fixed.
Vertica: Information about foreign keys can be extracted using native DB connection.
MS Access: The parser now accepts identifiers quoted with backticks and convert them to square brackets.
MS SQL Server: New MSSQL 2012 analytic functions are added.
MS SQL Server: OFFSET-FETCH clause is supported by Query Transformer.
MS SQL Server: IIF function and "WITHIN GROUP" clause are supported now.
MS SQL Server: Loading of foreign keys for SQL Server 2000 and earlier is fixed.
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!