Active Query Builder

Active Query Builder Blog

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.

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?

November 20, 2017

Do you really need Visual Query Builder?
Answers to frequently asked questions about Visual Query Builder.

April 26, 2016

How do you use the Alternate Names feature?
A feature that was primarily made to display clear names for database objects can be helpful in other cases.

August 14, 2015

First screenshot of Active Query Builder WPF Edition
Meet my first post in the Active Query Builder Blog.

First screenshot of Active Query Builder WPF Edition




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