Active Query Builder ASP.NET Edition provides a native and easy way to embed visual query building functionality into your ASP.NET and MVC projects. Active Query Builder is the first and only ASP.NET MVC Query Builder which brings full power of SQL language to the end-users by letting them build complex SQL queries with unions and sub-queries visually.
The client side of Active Query Builder ASP.NET Edition is written in pure HTML with CSS to separate the web page layout from the content for a quicker, efficient, and easier redesign. Built with the standard jQuery framework, Active Query Builder ASP.NET Edition provides rich interactivity through the advent of AJAX requests. Active Query Builder ASP.NET Edition takes an extremely low amount of web traffic and achieves a high throughput performance by minimizing all network packets through the use of light-weight libraries, code packing, on-the-fly compression, and JSON data formatting.
The query parsing and SQL text generation is performed on the server side. Active Query Builder ASP.NET Edition shares a common engine with the WinForms and WPF Editions.
Need a Query Builder for ASP or ASP.NET 1.1? Take a look at the Active Query Builder ActiveX Edition.
Learn more about the Main features of Active Query Builder for .NET.
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, 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.