Active Query Builder .NET Edition - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

Active Query Builder .NET Edition by Active Database Software

Build complex SQL queries via an intuitive visual interface. Active Query Builder .NET Edition is a visual query builder component suite that allows your end-users to build complex SQL queries with unions and sub queries via an intuitive visual interface. Active Query Builder .NET Edition supports Visual Studio 2005, Windows.Forms environment (100% Managed Code, No direct Win32 interop calls).

Common product information about Active Query Builder

Completely visual building of complex SQL queries.

MS-Access style and SQL Server style interface.

User-friendly interface with drag & drop support.

Powerful means of working with parameters.

Working in offline mode, storing metadata in XML files.

Delicate handling of user queries.

Sophisticated SQL parser.

SQL Server, Access, Oracle, MySQL and ANSI SQL/92 dialects support.

VistaDB desktop database support.

SQL Formatter.

Integration with C#, VB.NET and other VS2005 built applications is achieved by setting a few properties or adding a few lines of code.

The component may be integrated into your .NET 2.0 application with just a few lines of code. Unlike many other .NET query building solutions, Active Query Builder for .NET does not force the programmer to use the embedded data grid, SQL editor or anything else. Instead, it allows you to integrate any accompanying tools into your application as quickly and easily as possible.

Full access to internal query representation objects.

Active Query Builder gives you full control over the SQL query - you can easily navigate it using the internal query builder objects tree that represents all parts of the SQL query. Also you can edit existing queries or create new SQL queries using these objects in run-time.

ADO.NET and generic event driven driver.

We are planning to create metadata providers for all popular database connectivity components but, of course, we cannot cover them all. Thus we created the generic event-driven metadata provider. You can use it to provide metadata information from any data source. It's quite simple and has just a few events to implement. Using the generic event-driven metadata provider you can work disconnected providing all necessary metadata information by yourself. (Generic event-driven metadata provider will be available on release)

List of features of Active Query Builder .NET Edition.

Completely visual building of complex SQL queries

Visual building of sub-queries

Visual building of unions

Columns pane allowing to define grouping, sorting, and constructing criteria

Tree pane to browse and navigate query tree

Database objects tree pane to add objects to query

Forecast: Visual criteria constructing tool for Where and Having clauses - Not available in free edition

Powerful programming interface

Configuring the layout of generated SQL code

Retrieving the list of parameters found in the query - Not available in free edition

Retrieving extended information about parameters: datatype, related object, field and operator - Not available in free edition

Ability to work with metadata - Not available in free edition

Ability to build queries with objects from different databases - Not available in free edition

Pre-filtering of database objects to speed up metadata loading - Not available in free edition

Saving and loading all metadata information to XML format - Not available in free edition

Ability to work in offline mode - Not available in free edition

Full access to internal query representation objects - Not available in free edition

Support for various SQL Dialects

ANSI SQL/92

Microsoft SQL Server - Not available in free edition

Oracle - Not available in free edition

Microsoft Access - Not available in free edition

MySQL - Not available in free edition

Direct connect to VistaDB 3 - Not available in free edition

Several visual representation models

MS Access style

SQL Server Enterprise Manager style

Miscellaneous options

SQL Formatter: Plain text output filter to customize SQL code the way you like it

Full set of database connectivity options

OLE DB Metadata provider

MS SQL Server Metadata provider - Not available in free edition

Oracle Metadata provider (MS & Native) - Not available in free edition

MySQL Metadata provider - Not available in free edition

ODBC Metadata provider

Vista DB Metadata provider - Not available in free edition

Generic event-driven metadata provider

What's new in V1.7

IMPORTANT: The mistakenly named property "CriteriListOptions" has been renamed to "CriteriaListOptions"

Customization of datasource's field lists at the query building area has been made

The FieldListOptions property allows you to customize drawing of the datasource's field lists. You may show/hide/customize the following columns:

Status picture: is used now to mark Primary key fields only (FieldListOptions.MarkColumnOptions).

Field Name (FieldListOptions.NameColumnOptions)

Field Type (FieldListOptions.TypeColumnOptions)

Field Description: (FieldListOptions.DescriptionColumnOptions)

Field lists are retrieved now through the database server specific queries. This allows you to display field types for specific database servers correctly, also this may speed up retrieval of the field lists.

Building queries with grouping is much simpler now with the new behavior of the expressions grid control. The "Output" and "Grouping" check boxes are switched automatically in order to get correct SQL query all the time

All distributable assemblies have been signed with digital signature

MySQL and Firebird parameters parsing is improved

Other minor improvements and bug fixes are made.

What's new in V1.6

Sleep mode is implemented - This mode allows you to suppress error messages while printing unsupported statements in SQL text editor, connected with Active Query Builder. Active Query Builder now switches to Sleep mode when non-SELECT statement is passed to the SQL property. This allows your end-users to write any other statements, such as INSERT, UPDATE, DELETE, CREATE ..., ALTER ..., etc., without any additional processing

New properties are added to parenthesize conditions in WHERE clause

The new full-featured MDI Demo application with source code is added to the Trial and Standard versions

Tne new demo project is added to illustrate ability to modify queries programmatically (QueryModificationDemo)

The new source code sample is added to demonstrate non-standard ways of metadata loading (LoadMetadataDemo)

The new HideSingleDatabaseNode property is added to the QueryBuilder.MetadataTreeOptions to hide unnecessary database node if all objects are loaded from single database

Query properties dialog for PostgreSQL syntax is implemented

What's New in V1.5

Ability to define alternate names for database objects and their fields is implemented

Non-visual mode is added

New UniversalSyntaxProvider is added to the Free version - It is based on the ANSI SQL/92 syntax but allows to determine most of popular database servers, thus it successfully retrieves metadata and applies specific settings for them, to let the user build simple queries for these servers

New UniversalMetadataProvider is added - This metadata provider may operate with any valid Connection object, no matter what ADO.NET data provider you use

Firebird syntax: common table expressions are supported now

Memory and speed optimizations are made

Polish translation is added

What's New in V1.3.5

MySQL, PostgreSQL, Firebird, Sybase, IBM DB2 and Informix SQL dialects are supported now

Now it is possible to detect SQL syntax of the database server automatically using the AutoSyntaxProvider

Ability to perform basic conversion of SQL queries between dialects is implemented

Ability to retrieve metadata from VistaDB and Advantage Database Server is added

Improved usability of building GROUP BY/HAVING clauses with the new criteria list grouping style

Significantly increased speed of working

Ability to localize the component is implemented

Ability to customize or hide context menus using the ValidateContextMenu event is added

PartNumbers: PC-516519-168742 516519-168742 PC-516519-168743 516519-168743 PC-516519-168746 516519-168746 PC-516519-168744 516519-168744 PC-516519-168747 516519-168747 PC-516519-168748 516519-168748 PC-516519-168745 516519-168745

Publisher PartNumbers: 1682228 1682229 1684103 1688559 1708334 1732490

PurchaseOptions: Active Query Builder Standard .NET Windows Forms Edition V1.7 - without Source Code 1 Developer License , Active Query Builder Standard .NET Windows Forms Edition V1.7 - without Source Code 4 Developer Team License , Active Query Builder Standard .NET Windows Forms Edition V1.7 - without Source Code 8 Developer Team License , Active Query Builder Standard .NET Windows Forms Edition V1.7 - with Source Code 1 Developer License with Source Code , Active Query Builder Standard .NET Windows Forms Edition V1.7 - with Source Code 4 Developer Team License with Source Code , Active Query Builder Standard .NET Windows Forms Edition V1.7 - with Source Code 8 Developer Team License with Source Code , Active Query Builder Standard .NET Windows Forms Edition V1.7 - Source Code License 1 Source Code License (Requires that you already own a developer license)

Resources: Read the Active Query Builder .NET Edition help file, Read the Active Query Builder Standard .NET Edition DataSheet, Download the Active Query Builder .NET Edition V1.7 evaluation on to your computer - Limited Functionality

Operating System for Deployment: Windows XP, Windows 2000, Windows NT 4.0

Architecture of Product: 32Bit

Product Type: Component

Component Type: .NET WinForms, .NET Class, 100% Managed Code

Compatible Containers: Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C# 2008, Microsoft Visual C# 2005, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.0

Keywords: SQL query language Author active query builder, activequerybuilder, active querybuilder, active querybuilder