Active Query Builder .NET WinForms 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 supports Visual Studio .NET 2005-2019 (Windows.Forms, WPF and ASP.NET environments). The component was successfully tested with .NET Framework 4.x, .NET Core 2.x, 3.x, .NET 5.0 and 6.0.
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
The main object of Active Query Builder component suite is ActiveDatabaseSoftware.ActiveQueryBuilder.QueryBuilder. Place the component on a form and follow the steps of the configuration wizard to set up the component. If you don't want to use the wizard or it's unavailable, you should place a few more components to setup Active Query Builder properly. Below is the class diagram to illustrate the basics.
You may learn more in the Quick Start Guide.