Full Feature Matrix: Active Query Builder .NET Edition
| .NET Edition | ||
|---|---|---|
| Free Version | Full Version | |
Completely visual building of complex SQL queries |
||
| Visual building of unions, sub-queries, derived tables and CTE | yes |
yes |
| Design Pane to join tables in the query visually | yes |
yes |
| Expressions Grid to define criteria, grouping and sorting | yes |
yes |
| Query Structure Pane to browse and navigate complex queries quickly | yes |
yes |
| Database Objects Pane to add objects and fields to the query | yes |
yes |
| Datasource, Link and Query Properties dialogs to define various options | yes |
yes |
| Field Lists with ability to display data type and description | no |
yes! |
Powerful programming interface |
||
| Customizing generated SQL query text layout (SQL text formatter) | yes |
yes |
| Substituting real database object and field names with user-friendly aliases | no |
yes! |
| Retrieving the list of parameters found in the query and useful information them: datatype, related field, operator | no |
yes! |
| Altering metadata information (relationships between tables, field and table descriptions) | no |
yes! |
| Removing unwanted database objects from the list of selectable objects | no |
yes! |
| Preventing execution of queries with unwanted objects | no |
yes! |
| Adding complex expressions and sub-queries as ordinary fields ("Virtual fields") | no |
yes! |
| Adding SQL queries to the list of database objects ("Virtual database objects") | no |
yes! |
| Pre-filtering of database objects to speed up metadata loading | no |
yes! |
| Working without live database connection ("Offline mode") | no |
yes! |
| Saving all metadata information to XML file for future modification and faster loading | no |
yes! |
| Getting access to internal query representation objects for SQL query analysis and modification | no |
yes! |
Support for various SQL Dialects |
||
| ANSI SQL/92 | yes |
yes |
| Microsoft SQL Server | no |
yes! |
| Oracle | no |
yes! |
| Microsoft Access | no |
yes! |
| MySQL | no |
yes! |
| Firebird | no |
yes! |
| IBM DB2 | no |
yes! |
| Sybase ASA/ASE | no |
yes! |
| PostgreSQL | no |
yes! |
| Informix | no |
yes! |
| SQLite | no |
yes! |
| ANSI SQL/89 | no |
yes! |
| ANSI SQL/2003 | no |
yes! |
Several visual representation modes |
||
| MS Access style | yes |
yes |
| SQL Server Enterprise Manager style | yes |
yes |
Miscellaneous options |
||
| Ability to translate interface of Active Query Builder to any language | yes |
yes |
| Ability to switch languages in run-time | yes |
yes |
| Ability to detect SQL Syntax dialect automatically | no |
yes! |
Full set of database connectivity options |
||
| OLE DB Metadata provider | yes |
yes |
| ODBC Metadata provider | yes |
yes |
| Metadata providers for native .NET Data Providers | no |
yes! |
| Direct connect to Advantage Database Server | no |
yes! |
| Direct connect to VistaDB 3 | no |
yes! |
| Generic event-driven metadata provider | yes |
yes |
Learn more about Active Query Builder
News
- 07/23/2010
Active Query Builder ASP.NET Edition 0.2 Beta is released.
Many bugs are fixed, initialization is advanced, UI performance is improved. - 06/11/2010
The new SQL Text Editor and Expression Editor for .NET is available now.
Windows.Forms text editing control with code completion, syntax highlighting and much more. - 06/11/2010
Active Query Builder ASP.NET Edition is available for purchasing now.
- 06/11/2010
Active Query Builder .NET Professional Subscription is released
It guarantees access to all ActiveDBSoft products for .NET Framework at minimal price. - » All news
- Subscribe
Testimonial
With users expecting better and better interfaces to deal with complex data retrieval, Active Query Builder has allowed me to provide a highly professional, robust environment to both novice users and skilled query writers.
Thanks to all the team involved. Please keep up the good work.
Thanks to all the team involved. Please keep up the good work.
Duncan Deacon
