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.
Major improvements of the new version 1.5 are the following:
Ability to define alternate names for database objects and their fields is implemented. /Learn more/
The new UniversalSyntaxProvider is added to the Free version.
It is based on the ANSI SQL/92 syntax but allows to determine most of popular
database servers, successfully retrieve metadata and apply specific settings
for them to let the user build simple queries for these servers.
Please note that this does not mean that the Universal Syntax Provider could
be a suitable replacement for specific database syntax providers, as it
strictly follows the rules of ANSI standard, that may lead to many
incompatibilities while working with specific database servers.
Working with the Standard version, use the Auto Syntax Provider in case of
necessity to detect database server automatically.
The new UniversalMetadataProvider is added.
This metadata provider may operate with any valid Connection object, no matter what ADO.NET data provider you use.
Please note that this metadata provider is unable to retrieve metadata objects
from the connection, because implementation of DbConnection.GetSchema()
significantly differs for every ADO.NET data provider. Thus you need to use it
together with specific syntax providers that are able to retrieve metadata
objects via SQL queries. At the moment, UniversalMetadataProvider is operable
with DB2, Firebird, Informix, MSSQL, Oracle and PostgreSQL syntax providers
only.
The new query properties dialog for Oracle is added.
Firebird syntax: common table expressions are supported now.
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!