Active Query Builder

Active Query Builder News

April 03, 2018

Active Query Builder ASP.NET Edition 3.2 lets build cross-domain apps and use it in a Docker container.
Demo projects for AngularJS, React, WebPack and Electron are included in the installation package.

March 14, 2018

Domain-specific language API to define SQL queries
Typesafe SQL construction and database object referencing through the generated database schema code. Are you interested?

February 22, 2018

All demo projects of Active Query Builder for .NET are available on GitHub now.
They do not require Active Query Builder installed, all dependencies get automatically updated from NuGet packages. Just clone a repository and run!

February 21, 2018

Using Redis to store server-side objects instead of the ASP.NET session-based storage
The new version of Active Query Builder ASP.NET is not tied to the storage on the basis of the ASP.NET session but can store the state of server objects in any repository specified by the programmer.

February 20, 2018

Active Query Builder ASP.NET Edition 3.1 improves the API of the new major version.
The ability to edit the text of sub-queries separately from the entire query has been made. Usage of the ASP.NET session mechanism is no longer mandatory.

January 29, 2018

How can we help users build queries easier?
Over the last few weeks we've realized that we haven't done much to help ordinary users build ordinary queries faster, and we hope that it's not too late to fill this gap.

January 16, 2018

Our plans for Active Query Builder
Our main goal is to give the user an opportunity to think about the data he needs to get with the query.

January 15, 2018

Query Inconsistency Alerts
Reduce support requests by letting users be more competent and write better queries with Active Query Builder.

January 12, 2018

Faster, smarter SQL query builder
What advantages does the user get on upgrading Active Query Builder to the third version?

January 11, 2018

Active Query Builder for .NET 3.4 lets add linked objects easier.
The new version also better handles the user SQL expression errors, warns about the query inconsistencies, simplifies the work with large queries and database schemas, and also increases the performance on loading metadata.

Active Query Builder for .NET 3.4 lets add linked objects easier.




Join Types

Automatic Joins Creation
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.

Different Join Types
Active Query Builder allows to define different join types and various server-specific query options visually.

Unions and Sub-queries

Unions and Sub-Queries
Unions, sub queries and derived tables can be accessed and built visually in Active Query Builder as easy as the main query.

Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.

Active Query Builder Screenshots

Social networks