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

May 30, 2013

Active Query Builder 2 .NET Edition 2.3 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.3?

  • The new QueryTransformer component is added. It is intended to easily programmatically modify sorting, add filtration, aggregation and limits to SQL queries.
    See the "QueryTransformerDemo" source code sample and the Knowledge Book article for details.
  • SQL Text Editor: The new properties are added to improve usability of the code completion feature and to prioritize the content of suggestion lists:
    • The ShowSuggestionAfterCharCount property determines number of chars that should be typed before the suggestion list will popup;
    • The SuggestionListContent property allows to filter the content of suggestion list (keywords, SQL functions and metadata objects);
    • The KeepMetadataObjectsOnTopOfSuggestionList property being set to True instructs to act exactly what is written.
  • SQL Text Editor: The WordWrap property is added.
  • SQL Text Editor: Performance is improved.
  • The new MetadataContainer.ConnectionIdle event is added. It allows for closing the database connection if it's not desirable to keep it open during the work session.
  • The new events are added to BaseMetadataProvider: BeforeSqlExec and AfterSqlExec. They might be useful for tracing SQL queries sent to the database server.
  • Oracle: Optimizer hints can be edited via the Query Properies dialog.
  • Other minor fixes and improvements are made.
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