Here we describe how EasyQuery helps to implement a query building UI for creating custom, dynamic queries in .NET projects which use Entity Framework (6.x)
From this article you will see how to aggregate (count, sum, etc.) data in your queries.
In this article, you will learn how to build queries that contain both AND and OR operators.
For example, value editor allows you to define a list of available values - so your users will be able to select the value from a drop-down list. "Custom list" value editor raises an event which can be processed either on the client-side or on the server. All other editions of EasyQuery (WinForms, WebForms, WPF or Silverlight) has ListRequest event in QueryPanel control which is raised when a user adds an attribute (or operator) with Custom List or SQL list value editor assigned to that attribute/operator. Here we show how you can filter the returned list according to the value specified for some other attribute. If such condition is defined - we get the value (country code) from it and use that value as a filter for the list of regions.
This article is about settings for adding different options to the whole query (like DISTINCT, LIMIT, etc)
Paging can make your work with query more convenient. And here is detailed instruction on how to use it.
This article contains a brief instruction how to modify EqMvcDemoEF sample project to make it work with your own context class
Here you can find tips how to value editor setup and how to value editor widget
How to set up column formats and change default settings of the table.
Gridview filtering with EasyQuery ASP.NET (WebForms)
Example of how to build data model by certain information from DataTable
In this article, you can find instructions how to set up different types of date & time formats, with code examples.
Describes how to setup EasyQuery in ASP.NET Core web application
This article will guide you through all steps necessary to apply EasyQuery ASP.NET to MVC web application
This article describes how to implement the adhoc reporting functionality (similar to the one from our live demos) in your own project.
Detailed instruction with various examples of how to operate with different query formats.
How to build a simple query with 1-2 conditions over one table (entity)
How to upgrade your project from version 3.x to version 4.0 of EasyQuery
A code snippet which demonstrates how to run through all conditions in your query
It's easier to fill your model right in the code directly from your database, using meta-information
Step-by-step instruction how to setup SQL LIST value editor.
A code snippet which demonstrates how to execute this task
Here you can find all steps you need to perfom
Here you can find the instructions how to add EasyQuery components into your ASP.NET WebForms project
This article defines operators which can be used in conditions (such as 'is equal to', 'less than' and others).
Full instruction of how to remove “Powered by EasyQuery” link
Here we explain how to implement different ways to limit the quantity of entities and attributes shown in Data Model
EasyQuery allows to add new aggregate functions for user's need. Here is detailed manual of how to do it with code example.
This article described how to set up an advanced search page in your web-application using EqMvcDemoDB project as a template.
How to upgrade your project from version 2.x to version 3.0 of EasyQuery
Here is a step-by-step description what you need to achieve this goal
An example of query which require to define a table join(s) in case of using SQL. It's much more simple with EasyQuery.
Here you can find all steps you need to perform
In this article, you can find two methods of localization of EasyQuery components
A code snippet which demonstrates how to do this task
How to limit columns from duplication in MVC project, so when you add a column that is already used in a report it won’t be added again.
Here you can find out how to strengthen security of your project using antiForgeryToken option.
Here we describe how to apply the product key that you get after purchasing the license and which allows you to unlock all the features of EasyQuery library.
This article shows how to apply EasyQuery.NET to your application
Example of how to solve this problem
A code snippet which demonstrates how to run through data model entities and attributes
The instructions on how to add a condition which compares a field against another field instead of constant value.
In this article, you will find the detailed instructions how to modify WebDemoCS or WebDemoAjaxCS to make it work with SQL Server instead of Access
In this article, we provide all the information needed to use aliases properly. There is an explanation, what for aliases are in the DME and an example of using it.
This article explains how to work with parameterized conditions.
Example of code for adding columns and conditions
First, of you will need to assign a custom (user-defined) value editor for some attribute or operator in your data model. You have to ways to do it: Run Data Model Editor (DME). Select an entity attribute which you want to assign custom value editor to. You can add a custom editor to any entity attribute in your model at run-time. Here is an example of very simple value editor in TypeScript.
This article shows how to implement some particular tasks with your query
Detailed instruction on how to perform additional functionality while dealing with EasyQuery results.
This article will guide you through all steps necessary to apply EasyQuery.NET to your application, with extract examples
In this article, you can find the instructions how to replace native WebForms with our jQuery widgets, with extract examples
You will be able to apply EasyQuery WPF to your application, performing all the instructions in this article
This article shows how to localize widgets, with extract examples