EASYQUERY

Build a .NET database application simple and easy

Long story short, EasyQuery will be useful to you if you are creating a .NET application that works with a database.



OVERVIEW

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!
{

01. 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.

02. 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.

03. Data visualization

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.



USECASES

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...

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.

Live demo...

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



SCREENSHOTS



EASYREPORT

EasyReport Starter Kit (ERSK)

ASP.NET Core solution template for ad-hoc reporting

  • Report management with visual query builder
  • Data visualization (tables, charts, pivots etc)
  • User access management with roles, guest access
  • Data export, scheduled reports, and more

Don't build everything from scratch. Use ERSK as the starting point!



EASYQUERY.JS

EasyQuery.JS is a JavaScript framework that makes it easy to implement advanced search, data filtering or adhoc reporting scenarios (like on the screenshots) in your web application.

So, as you can see EasyQuery.JS gives you a simple to use but powerful user interface to build a query or a filter to your data. Your end-users will get the power of SQL (even if they can't pronounce it properly) with the simplicity of the natural language.



SUPPORTED TECHNOLOGIES

PLATFORMS

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

DATABASES

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

QUERY LANGUAGES

  • SQL
  • Entity SQL
  • Linq
  • Filter Expression

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).

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).

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).

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.

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.

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.

LICENSE PRICE

Read the End User License Agreement before installing EasyQuery.

ASP.NET CORE

Basic
$249
Pro
$499
Developer
$1199
Company
$1999
Features BUY NOW BUY NOW BUY NOW BUY NOW
Number of Developers 1 1 Up to 5 Unlimited
Source Code
Standard Support
Premium support
Non-exclusive life-time license
Free redistribution with your product

ASP.NET

Basic
$249
Pro
$499
Developer
$1199
Company
$1999
Features BUY NOW BUY NOW BUY NOW BUY NOW
Number of Developers 1 1 Up to 5 Unlimited
Source Code
Standard Support
Premium support
Non-exclusive life-time license
Free redistribution with your product

WinForms

Basic
$249
Pro
$499
Developer
$1199
Company
$1999
Features BUY NOW BUY NOW BUY NOW BUY NOW
Number of Developers 1 1 Up to 5 Unlimited
Source Code
Standard Support
Premium support
Non-exclusive life-time license
Free redistribution with your product

Silverlight

Basic
$249
Pro
$499
Developer
$1199
Company
$1999
Features BUY NOW BUY NOW BUY NOW BUY NOW
Number of Developers 1 1 Up to 5 Unlimited
Source Code
Standard Support
Premium support
Non-exclusive life-time license
Free redistribution with your product

WPF

Basic
$249
Pro
$499
Developer
$1199
Company
$1999
Features BUY NOW BUY NOW BUY NOW BUY NOW
Number of Developers 1 1 Up to 5 Unlimited
Source Code
Standard Support
Premium support
Non-exclusive life-time license
Free redistribution with your product

DELPHI/VCL

Standard
$129
Developer
$199
Professional
$249
Site
$689
Features BUY NOW BUY NOW BUY NOW BUY NOW
Number of Developers 1 1 1 Unlimited
Source Code
Standard Support
Premium support
Non-exclusive life-time license
Free redistribution with your product
You may freely use EasyQuery.NET for evaluation purpose and/or in non-profit projects.

FREQUENTLY ASKED QUESTIONS

Do I need to pay some additional fee per domain, or per user, etc.?

No. The license price is final, no additional fees. Once you purchased the EasyQuery you may use it in any number of your projects for any number of end users or site visitors. There are NO deployment limitations.

We provide annual subscriptions for our products to give you access to the latest releases and support.

What forms of payment do you accept?

We accept payment via credit card, check, paypal, wire transfer and some others. You can select the acceptable payment method on the order form.

How can I get a quote?

Click the appropriate "Buy Now" button in the table above to open the order page. At the end of that page you will find "Get Quote" button. Fill out the form and press this button to get a quote.

What is subscription?

The subscription is annual fee we take to give you access to the latest releases and support. Valid subscription allows you to download a new versions of the Product. When the new version is released you don't need to pay for upgrade - just download it from our Members Area.

The first year subscription is included to the license price.

With expired subscription you will no longer have access to new releases and support. You will be able to renew the expired subscription (so called "welcome back"), but it will cost you more than twice as much.

How much does the subscription cost? How can I purchase it?

The 1-year subscription renewal costs about 25% of license price for those who renew the subscription in time - before the expiration date. And there is a "welcome back" price - about 70% - for those who are late.

To purchase the subscription go to your account page, sign in, find "Licenses" panel and click the "Renew" link on the right of selected license.

To get the lower price the renewal should be done before the subscription expiration date. You can find the expiration date on the Licenses page of our Members Area. We also will remind you several times by e-mail.

Can I continue using EasyQuery when my subscription expires?

Yes you can. Your EasyQuery license is perpetual. However, you will be using the last product version released before your subscription expired.

If you choose not to renew your subscription, you will no longer have access to new releases and support, and we will be very sad.

How do the licenses work?

Your license is tied to your Korzh.com account.

To get the full (registered) copy of EasyQuery simply log into your account page and download the latest version of the product.

What about support?

We offer sterling support online in order to make you succeed. You may initiate a support ticket on this page.

Do you have money-back guarantee?

We provide the full featured Community edition for free. We hope that you tried to use it during some time to make an informed decision purchasing the product.

Unfortunately, we can not give money-back guarantee on Company license. So, please be attentive - the Company license is non-refundable!

We are resellers. Do you have any special offers for resellers?

Yes, we have. Go to reseller's FAQ for details