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 complex SQL queries with unions and subqueries via an intuitive visual interface.

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

• 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.
  • Restricting access to unwanted objects
  • Sophisticated SQL parser.
  • SQL Server, Access, Oracle, MySQL, PostgreSQL, Firebird, Sybase, IBM DB2, Informix and ANSI SQL/92 dialects support.
  • Direct connect to VistaDB 3 and Advantage Database Server.
  • 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 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)

• 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