EasyQuery

Data management framework for your .NET application that helps you with:

  • dynamic custom queries (advanced search)
  • ad-hoc reporting
  • aggregation and grouping
  • paging, filtering, sorting, and many other tasks

All of the above with a simple, user-friendly UI and an efficient back-end processing engine

Version 7.2 is out! Release Notes | Changelog

Overview

Long story short, EasyQuery will be useful to you if you are creating a .NET application that works with a database. Because, after all, any developer that creates database applications most likely faces the following tasks sooner or later:

1. Organizing the data flow

Any data processing in a database application usually begins and ends at the presentation level. The user asks the system for some data, this "request" is converted into a query (or several queries) to the database, we receive data from there, process it, format it if necessary and send it back for display in the UI.

EasyQuery is there to help you implement the whole process with minimal effort.

2. Complex queries

In many projects, the number of parameters by which you can search for data is in the tens or even hundreds. EasyQuery provides a unified and easy-to-use UI for building complex queries on many parameters, converting them into database queries and displaying results.

3. Visualization of queries and result data

EasyQuery includes many visual components both to build complex queries and to display the results of those queries in all possible variations. It includes different widgets that represent the query (QueryPanel, ColumnsPanel, etc), a multifunctional table (grid) to display the result, pagination controls, aggregation and grouping UI, charts, dashboards, ad-hoc reporting components and many other UI widgets.

Use cases

As we said before, EasyQuery will be helpful almost of any database application. However, for some most common scenarios we create a ready-to-use sample projects that you start using right away with a minimal adjustments to your data model and the database type. Here are these scenarios:

  • Ad-hoc reporting

    Have you ever heard from your customer: "We need to change 3 reports and create 5 new"? Have you calculated the time and energy spent on all these trifles?

    With EasyQuery you give you users the ability to build/change queries for reports, save and load them, draw charts and export results.

    You don't even need to build such an application from scratch! Using our EasyReport Starter Kit you will get a ready-to-use reporting solution with multi-tenancy, data exports, scheduled reports and many other useful feature. You can just get the code, white-label the application and deploy it to your web-server.

    Live demo...

  • Advanced search form

    What if your users need to search by many different parameters and in various combinations? Typical search form looks like a mess of different controls related to one database field each. It may occupy the full screen but even in this case it may not cover all possible combinations of conditions.

    Do your users fated to use such ugly forms? Not with EasyQuery!

    The EasyQuery interface is laconic and intuitive, it allows to build almost any combination of conditions your users could wish for.

    Live demo...

  • Data filtering UI

    Whenever you show the grid with more than several rows of data, your users may need to filter the data somehow. Usually, you don't know how exactly they need to filter the data. Let them use EasyQuery and relax! They will do the job easily and will be happy.

    Live demo...

  • Simple text search

    Querying the data is relatively easy if know what and where you want to search. But what if you don't?

    Imagine that you need to find any mention of some word or phrase through the whole database, in any possible field. Moreover, you may want to limit the searchable data by some criteria.

    With EasyQuery you are one step away from success.

    See our short video that demonstrates how to implement such a scenario in 5 minutes.

    Live demo...

...or any other end-user interface related to data manipulating

See EasyQuery in action

EasyQuery Editions

EasyQuery ASP.NET Core

EasyQuery allows you to integrate end-user-oriented query builder into your ASP.NET Core project.

  • Friendly, natural language query builder UI: users do not need to know about your tables, links, fields or any other DB-related things.
  • Works with Entity Framework Core 2.0 and 3.0.
  • Supports any database that has a .NET Core connector.
  • Targets .NET Standard 2.0 and 2.1 (for Entity Framework Core 3.0)

ASP.NET Core edition of EasyQuery may be used with almost any front-end platform and/or framework (MVC, Razor pages, Angular, React, Vue, etc).

Try it now Pricing

EasyQuery ASP.NET

Ad-hoc query builder is a useful addition to WebForms and MVC web-app that requires some functionality for advanced searching and/or filtering. EasyQuery ASP.NET components provide your application with a powerful and easy-to-use interface for visual query building. It helps your users build their own queries and reports without the necessity to call for additional assistance or to contact your support team.

  • All kinds of ASP.NET and ASP.NET Core projects are supported: WebAPI, MVC and even WebForms.
  • Friendly, natural language query builder UI: users do not need to know about your tables, links, fields or any other DB-related things.
  • Programming language: C# (can be used in VB.NET or any other .NET languages as well).
  • Supported databases: SQL Server, Oracle, MySQL, PostgreSQL or any other databases that has a .NET connector
  • The latest version (5.x) supports .NET Framework 4.6.1 (and higher).
  • Version 3.x (now discontinued) supports also old .NET Framework versions (from 3.5 till 4.6).
Download free trial Pricing

EasyQuery WinForms

Dynamic SQL query builder will be a good addition for any Windows Forms application (especially a database-related one). EasyQuery WinForms is designed to help you with this task. As a result, your C# or VB.NET application get an end-user-oriented query builder which helps your users to run any queries they can imagine without any additional assistance from your support team. EasyQuery components allow them to build even complex queries or filter expressions visually simply by assembling a phrase in natural language.

  • Natural language user interface for query building.
  • Distributed as 100% pure .NET assemblies.
  • Written in: C# (can be used in VB.NET or any other .NET language as well).
  • Databases: MS Access, MS SQL Server, Oracle, MySQL, PostgreSQL or any other database as well as object-relational-mapping solutions (like Entity Framework)
  • The latest version (5.x) supports .NET Framework 4.6.1 and higher.
  • Version 3.x (now discontinued) supports also old .NET Framework versions (from 2.0 till 4.6).
Download free trial Pricing

EasyQuery WPF

EasyQuery WPF will be a good addition for any database application built on top of Windows Presentation Foundation library. Our components allows you to include end-user-oriented query builder into your program and helps your users to build and run any queries by their own without contacting your support team.

Download free trial Pricing

EasyQuery Silverlight

EasyQuery Silverlight will be an useful addition to any Silverlight project which works with some database. This library allows you to include end-user-oriented web-based query builder into your page(s) and helps your users to build their own reports without necessity to contact your support team.

  • Distributed as 100% pure Silverlight assemblies.
  • Silverlight versions: 4.0 and 5.0.
  • All types of databases are supported.
Download free trial Pricing

EasyQuery Delphi/VCL

SimpleQuery is a Delphi (VCL) edition of our EasyQuery product family. This component library allows you to integrate end-user-oriented query builder into your Delphi or C++Builder project. Try it now: it will take only 20-30 minutes to include SimpleQuery components into your existing project!

  • Programming language: Delphi Pascal.
  • Distributed as 100% pure Delphi packages.
  • Supported Delphi versions: 6.0 and higher.
  • Supported databases: Paradox, MS Access, MS SQL Server, Oracle, MySQL, PostgreSQL as well as any other database which can be used with Delphi or C++ Builder.
Download free trial Pricing

Supported Technologies

Platforms

  • ASP.NET Core
  • ASP.NET MVC
  • ASP.NET WebForms
  • WinForms
  • WPF
  • Silverlight

Databases

  • SQL Server
  • MySQL
  • Oracle
  • MS Access
  • Postgre SQL
  • etc.

Query Languages

  • SQL
  • Entity SQL
  • Linq
  • Filter expression

Next Steps

Try EasyQuery
Free trial with dedicated technical support
Read documentation
User's guide, knowledge base, API reference
Buy EasyQuery
Check out the pricing options

Our Customers

...and what they say