Active Query Builder  »  SQL Query Builder

Metadata Handling and Filtration

Various ways to load and represent metadata in Active Query Builder

  • Metadata pre-filtering

    When building a query, it's not necessary to load all metadata at once. Active Query Builder allows you to filter database objects by the database and schema name, object name mask, and object type (table, view, synonym, procedure and function). Partial metadata loading speeds up the metadata loading process for large database schemas.

    If a database server lets you use objects from different databases in a single query, Active Query Builder can be instructed to load metadata from several databases at once.

  • Working while disconnected from a database, loading metadata programmatically, storing metadata in XML files.

    Active Query Builder can work with any database access library, OLE DB, or ODBC data provider. But when a direct connection to a database is undesirable or even impossible for reasons of security or performance, for example in a multi-tier environment, the most convenient solution is to load metadata from a pre-generated XML file or fill the Metadata Container programmatically.

    Code samples illustrating various ways of metadata loading can be found in the Load Metadata demo project included in the installation package.

Related articles of the Knowledge Book:
Detailed information about Active Query Builder:




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!

Social networks