Active Query Builder .NET Edition

Descripción | Precio y licencia | Evaluaciones y descargas | Compatibilidad | Datos del autor | Opiniones | Foro | Resumen

Por favor note que al menos que se indique lo contrario, esta es la versión en Inglés del producto.
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).

Nuestros precios Standard están indicados abajo. Inicia una sesión para ver sus precios con descuento.

Active Query Builder Standard .NET Windows Forms Edition V1.7.5 - without Source Code

Active Query Builder Standard .NET Windows Forms Edition V1.7.5 - with Source Code

Active Query Builder Standard .NET Windows Forms Edition V1.7.5 - Source Code License

Nuestros precios incluyen servicio técnico de ComponentSource y, para la mayoría de los productos disponibles para descarga, una copia de seguridad en línea y una actualización GRATUITA a la nueva versión si ésta se publica en un período de 30 días después de la compra.  Todas las ventas están sujetas a nuestros Términos y condiciones standard y a nuestra Política de devolución. Por favor, póngase en contacto con nosotros si necesita alguna opción de licencia no incluida en la lista anterior, incluida la compra por volumen de licencias y versiones anteriores.

Nuestros precios Standard están indicados arriba. Inicia una sesión para ver sus precios con descuento.

What's new in V1.7.5

• The new look of the Expression column drop-down list is made
• The new demo for Delphi Prism is added
• German translation is added

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

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