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.12?
General improvements:
New feature: Virtual database objects and fields. It allows to hide complex expressions and sub-queries behind ordinary fields and save derived tables as ordinary database objects. See the Virtual Objects And Fields source code sample for demonstration and details.
Metadata and syntax providers for Microsoft SQL Server Compact Edition are made.
Re-arranging of criteria list items by drag and drop is implemented. You can drag items using row headers only. To set up the row headers width use the CriteriaListOptions.RowHeaderWidth property.
WPF Demo project is added. Active Query Builder is used there in a WPF window through the WindowsFormsHost.
API improvements:
DiagramObjectDeleting event is added. It notifies you that a user are trying to delete an object from the diagram pane and allows to prevent the deletion.
New FieldListDescriptionColumnOptions.UseLongDescription property is added to control which description will be shown in the Description column of field lists: if false (default), the MetadataField.ShortDescription is displayed; if true, the MetadataField.LongDescription is displayed.
New property LoadJoinsFromWhereClause is added. Using this property you can instruct the Query Builder to not treat WHERE conditions like "tbl1.FieldName = tbl2.FieldName" as joins. They will be loaded in the Columns pane instead.
The new method GetSchemaNames is added to syntax providers to retrieve the list of database schemas.
The new properties are added to the QueryBase class to set up unifying operator programmatically: UnionOperator, UnionAllFlag, UnionOperatorFull.
SQL Syntax fixes and improvements:
Sybase and MS SQL Server (only if ServerVersion < MSSQL2005): Support for old-style TransactSQL outer joins: "*=" and "=*" operators is made.
MS Access: Bug with unsupported FULL OUTER JOIN 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!