Active Query Builder .NET Edition

.NET 2.0 Windows.Forms Visual Query Builder

Active Query Builder .NET Edition is a visual query builder component suite that allows your end-users to build SQL queries via an intuitive visual interface. It's powerful API allows to parse complex SQL queries for programmatic analysis and modification.

Active Query Builder .NET Edition supports Visual Studio .NET 2005 and 2008, Windows.Forms environment. The component was successfully tested with .NET Frameworks 2.0, 3.0 and 3.5. Active Query Builder is tested with Delphi Prism for .NET; sample project is available.

• Common product information about Active Query Builder
  
  • Easy visual building of complex SQL queries with unions and sub-queries.
  • MS-Access style user-friendly interface with drag & drop support.
  • Two-way SQL query building (combined with SQL text editing).
  • Defining user-friendly aliases for tables and field names.
  • Powerful means of SQL query analysis and programming modification.
  • Working in offline mode, storing metadata in XML files.
  • Restricting access to unwanted objects, preventing query execution.
  • Sophisticated SQL parser, support of most popular database servers.
  • SQL query text formatting.
  • Ability to localize the component
• Integration with C#, VB.NET and other VS-2005/2008 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 (and higher) application with just 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.

• SQL parser with full access to internal query representation objects.

  Active Query Builder gives you full control over the SQL query - you can easily parse SQL queries and navigate them using the internal query builder objects tree that represents all parts of the SQL query. You can edit existing queries or create new SQL queries using these objects in run-time. (See the Non-visual and Query Modification demo projects that included in the Trial version)

• ADO.NET and custom metadata providers.

  We are planning to create metadata providers for all popular database connectivity components but, of course, we cannot cover them all. Thus we provided the other ways to load metadata to the query builder from any data source. Using them you can work disconnected providing all necessary metadata information by yourself. (You may learn more about different ways to load metadata at the Load Metadata demo project that included in the Trial version)

• User interface built with Standard WinForms controls or with DevExpress DXperience controls.

  The new user interface of Active Query Builder .NET Edition based on the DevExpress DXperience WinForms controls will allow you to perfectly match the appearance of the component with the rest of your application.
  ^* DevExpress User Interface for Active Query Builder .NET Edition is available as a separate option.

• Take a look at the full list of features of Active Query Builder .NET Edition.

• .NET Query Builder. Feature Matrix
• .NET Query Builder. Reasons to use
• .NET Query Builder. Screenshots
• .NET Query Builder. Download
• .NET Query Builder. Purchase