Active Query Builder for .NET

Professional .NET Subscription

Professional .NET Subscription bundles WinForms, ASP.NET and other .NET-based editions that will be available in the future (WPF, Silverlight - in 2014). It also provides valuable WinForms additions to build professional good looking query building environment. The Source Code of Active Query Builder is a separate purchase option of Professional .NET Subscription.

Advanced SQL Text Editor and Expression Editor

Experienced query writers won't usually need a visual query builder to write a query. They can use it to represent a query visually in order to understand its structure. For such users a powerful text editor is of high importance. The Professional version of Active Query Builder includes SQL text editor with such essential features as code completion and syntax highlight. It uses Active Query Builder's parsing engine to determine the current context and display the proper completion lists.

Key features:

  • Easy access to the list of database server keywords, operators and functions.
  • Easy access to the database schema information.
  • Code completion and context-sensitive suggestion lists.
  • SQL syntax highlight.

The same editor can be used in the visual user interface to build complex SQL expressions and criteria. It can be accessed by clicking the ellipsis button in the appropriate query columns grid cells in order to edit their values using the fully functional text editor instead of the in-cell editor.

SQL Text and Expression Editor

User interface built with DevExpress controls

Those developers who build professional database applications don't usually rely on standard .NET controls, but rather use advanced third-party sets of controls to ease the development and end-user interface. For those who use the DevExpress controls in their applications we have rebuilt the user interface to perfectly match the look of the component with all the rest of your application.

Note: We do not ship the DevExpress controls among with the Active Query Builder. A license for DevExpress DXperience WinForms controls is required to use this UI.

DevExpress controls UI

Full Source Code

Active Query Builder itself does not use any third party proprietary or open-source code. It is fully written in C# and does not require any third-party assemblies to work. Thus, it can be compiled from sources without the need of any additional libraries. The Professional .NET Subscription may be optionally purchased with the full source code, which allows for implementing the custom modifications needed in rare cases. Full source code may also serve for you as an additional warranty for the independence of your project from force majeure.

News

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.