Active Query Builder  »  SQL Query Builder

Metadata Handling and Filtration

Various ways to load and represent metadata in Active Query Builder

  • Metadata pre-filtration

    Sometimes it's not necessary to load it all at once to build a query. Active Query Builder allows filtering database objects by the database and schema name, by object name mask, as well as by object type (table, view, synonym, procedure and function). Partial metadata loading speeds up the metadata loading process in the case of the large database schema.

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

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

    Active Query Builder can work with any database access libraries, OLE DB and ODBC data providers. But when direct connection to the database is undesirable or even impossible for reasons of security or performance, for example in a multi-tier environment, the most convenient solution would be to load metadata from a pre-generated XML file or filling 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:

News

Testimonials

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