We're glad to announce the new version of Active Query Builder .NET Edition. You can download the newest version or request the trial at the download page.
What's new in the Active Query Builder .NET Edition version 1.10?
General improvements:
Support for DevExpress 2009.1 controls is added.
To use DevExpress controls, you should add a reference to the
ActiveQueryBuilder.DevExpressControlFactory.dll file to your project
or you may simply put the .dll near by your executable file.
In the Main() function of your application, before any form creation,
set up the DevExpress usage and turn on QueryBuilder's static property
"UseDevExpressControls":
Your project also must refer to DevExpress.Data.*, DevExpress.Utils.*,
DevExpress.XtraEditors.*, DevExpress.XtraGrid.* and DevExpress.XtraTreeList.*
assemblies.
Installation package now contains source code of metadata providers that
depend on third-party ADO.NET providers. If you need to use some specific
ADO.NET library version, you can rebuild a metadata provider with new
references without our assistance.
API improvements:
The new property is added to allow visual setting of NULLS FIRST/NULLS LAST
options: queryBuilder.CriteriaListOptions.ShowNullOrderingInSortTypeColumn.
New property InnerKeywordInLinks is added to SQLBuilder and
QueryBuilder components to suppress the "INNER" keyword in joins.
The new CriteriaListControlInitialization event is added for additional
customization of the grid.
TableChecksCountInCaption property is renamed to CheckedFieldsCountInCaption.
SQL Syntax fixes and improvements:
Firebird 2.5 support is added.
MS SQL Server: Loading synonyms info for SQL Server 2005 is made.
PostgreSQL, DB2, SQL2003: Support of NULLS FIRST and NULLS LAST is added.
PostgreSQL: Escaped and unicode string literals support is added.
DB2: Support of CONCAT operator is added.
SQL2003: Support for OVERLAPS expression is added.
Sybase ASE support is fixed.
MSSQL: NULLIF function support is fixed.
PostgreSQL: SIMILAR TO operator support is fixed.
PostgreSQL: The bug in parsing of 'interval' type is fixed.
Query builder was not loading the scale of table columns. Fixed now.
Fixed the "NOT IN", "NOT LIKE" and "NOT BETWEEN" clauses were being split apart
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!