Active Query Builder for .NET (ID #26268)

Active Database Software

Active Query Builder .NET Edition is a visual SQL query builder component for Windows.Forms environment, .NET Framework 2.0 and higher that allows your end-users to build complex SQL queries via an intuitive visual query building interface easily. It is a perfect choice for both SQL beginners and experienced query writers. Active Query Builder renders all SQL features, such as sub-queries and unions, very easy to accomplish and provides the professional user with everything he or she needs to efficiently work with queries.

The interface of Active Query Builder is similar to MS Access and SQL Server’s visual query building interface, so it is already familiar to most database users. Active Query Builder practically eliminates mistakes when writing SQL queries while achieving almost instant results. By embedding Active Query Builder into your product, you can make it easy for beginners and provide a powerful tool for professionals.

Active Query Builder provides maximum flexibility to your users without your software losing control over the operations it performs: the fields and tables the user selects in a query and the data that gets displayed on the screen. No more parameter problems; Active Query Builder lets you find out not only each parameter’s name but also the names of each table and field that each parameter applies to.

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. You can edit existing queries or even create new SQL queries in run-time.

Active Query Builder supports Oracle, Microsoft SQL Server, MS Access, MySQL, PostgreSQL, Informix, Sybase, Interbase, Firebird, and other SQL dialects. There are two editions available: the Standard Edition and the Free Edition. The Free Edition is fully functional, but supports only the ANSI-92 SQL dialect.

Other advanced features:
- Defining user-friendly aliases for tables and field names.
- Working in offline mode, storing metadata in XML files.
- Restricting access to unwanted objects, preventing query execution.
- SQL query text formatting.

Active Query Builder for .NET home page