Below is the list of fixes and improvements in Active Query Builder WinForms Edition v.220.127.116.11 Beta.
+ Ability to define alternate names for database objects and their fields is implemented.
[ Legend: ] [ + New feature ] [ = Improved/changed feature ] [ - Bug fix ] [ ! Important notice ]
To define alternate names, use the MetadataContainer.Edit method to call the Metadata container editor and enter alternate names for each required database object and field. To do this programmatically, you may use the AltName property of the MetadataObject and MetadataField objects that are items of the MetadataContainer collection. Another way to define alternate names is to set them in the XML file that stores metadata information. You should use the "alt_name" sub-element of the "object" and "field" elements to define alternate names.
The use of alternate names is turned on by default. You can control this feature with the UseAltNames properties of the QueryBuilder and PlainTextSQLBuilder objects. QueryBuilder.UseAltNames property controls the presence of alternate names in the user interface (trees, lists and dialogs). PlainTextSQLBuilder.UseAltNames property controls the presence of alternate names in the formatted query text output. Users can use both real and alternate names in the query; Active Query Builder is able to parse such mixed queries correctly.
You should use the PlainTextSQLBuilder.SQL property to get the end-user SQL text with alternate names, and the QueryBuilder.SQL property to assign such SQL text after editing by the end-user. The new QueryBuilder.SQLForServer property is added to retrieve the SQL text with real database object and field names, that should be passed to the database server.
Please check the "AlternateNames" demo project for details (included in the installation package).
You can always get the latest trial version of Active Query Builder WinForms Edition at the download page.
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!