Active Query Builder for NET is available for WinForms and ASP.NET environments. Versions for WPF and Silverlight environments will be available soon.
Active Query Builder is not just a component to build SQL queries visually. It's is a full-featured set of tools to manage metadata, work with SQL queries, and assist in retrieval of data from the database.
Active Query Builder lets create full-featured applications quickly to retrieve data from almost any database. It provides highly customizable and convenient interface for end-users to understand database schema and to work with queries in the most efficient way.
Automatic Joins Creation
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.
Different Join Types
Active Query Builder allows to define different join types and various server-specific query options visually.
Unions and Sub-Queries
Unions, sub queries and derived tables can be accessed and built visually in Active Query Builder as easy as the main query.
Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.