We're glad to announce the new minor version of Active Query Builder. You can download the newest version from the download page.
What's new in the Active Query Builder version 1.6?
Storing and loading metadata information from an XML file makes loading metadata almost instant regardless of the number of objects being loaded. This also reduces the workload of the database server by making it unnecessary to request metadata from the server.
Now Active Query Builder supports working in offline mode, loading metadata information from a previously saved XML file. This is very convenient if the component is used to work with a remote database, for example in the ASP.NET environment. In many cases, direct connection to the database is undesirable or even impossible from the point of view of security or performance. In this case, the most convenient solution would be to work with Active Query Builder in offline mode.
The XML file can be created using one of the following methods:
To load metadata from the XML file, assign the string containing the XML code to the XML property of the MetadataContainer object, or, alternatively, use the LoadFromXMLFile method. If you want to avoid database requests at all, set the OfflineMode to True.
Code example of saving metadata to XML file programmatically:
QueryBuilder.OfflineMode := True; QueryBuilder.MetadataContainer.LoadMetadataByMask('%', '%', 'Northwind'); QueryBuilder.MetadataContainer.LoadMetadataByMask('%', '%', 'Southwind'); QueryBuilder.MetadataContainer.SaveToXMLFile('winds.xml');
Code example of loading Metadata from XML file:
QueryBuilder.OfflineMode := True; QueryBuilder.MetadataContainer.LoadFromXMLFile('winds.xml');
* These features will be available in the Standard Edition of Active Query Builder only.
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!