How to remove "Powered by..." link (full version only)
/how-to/mvc-remove-powered-byFull instruction of how to remove “Powered by EasyQuery” link
About Data Model Editor
/data-model-editor/aboutHere you can find detailed information about this instrument and guideline, how to use it to perform all needed tasks.
Data Model
/fundamentals/data-modelIn short (and by its name), data model - is a model (representation) of some data stored in your database. It solves two major problems: Presents the data to the end user in a more friendly and familiar way. Contains some meta information that helps EasyQuery components to build query statements in SQL or other query languages. Any data model contains the following main sections:
Value Editors
/data-model-editor/value-editorsHere you can find the full list of editors and choose any you need in your work with Data Model:
Aggregate data
/tutorials/aggregate-dataFrom this article you will see how to aggregate (count, sum, etc.) data in your queries.
Working with several data models
/tutorials/several-data-modelsAll EasyQuery demos works with one data model (and one database which corresponds to that model). Here we are going to describe how to add a selector that switches between two data models on your view/page and then how to setup a custom "model loader" to handle GetModel requests propertly. To make it possible to switch between these two models we need some selector element on our page. The only problem here - is to switch the database connection accordingly the the switches between the models. Now when the user selects an item in our model selector element on the client-side - our server-side code automatically loads the selected model and connects to a proper database (when necessary)..
Possible ways of data model creation and loading
/tutorials/data-model-creation-loadingEasyQuery components need a [data model](/$aid/03bc06b0-83ec-4040-97ef-a50ca004177f) (a user-friendly representation of your DB) for their work. There are several different ways to create the model and load it on your project's startup. This article will describe all of them in detail.
Navigate through data model entities and attributes
/how-to/run-through-data-model-entitiesA code snippet which demonstrates how to run through data model entities and attributes
Building data model dynamically by DB meta-information
/how-to/build-data-model-by-db-meta-informationIt's easier to fill your model right in the code directly from your database, using meta-information
Adding a new operator to your data model
/tutorials/add-new-operatorHere you can find all information about how to add a new operator to your data model either using Data Model Editor (DME) or with a code
Creating data model dynamically with code
/how-to/create-data-model-dynamically-with-code-Data Model- object is an essential part of EasyQuery framework. However, sometimes you need to add some entities, entity attributes or operators to the existing model or to fill it from scratch using DB metadata information got from another source. In these cases, you can use EasyQuery API to build the model dynamically. Finally, we add entities and entity attributes. Here is an example of creatin a small data model: two tables (Customers and Orders) with one link between them, 2 entities (Customer and Order correpondingly) and a few attributes in each entity.
Building data model dynamically by information from a DataTable
/how-to/build-data-model-by-info-from-datatableExample of how to build data model by certain information from DataTable
Introduction to value editors
/fundamentals/about-data-editorsFor 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.
Working with data models in EasyQuery
/getting-started/working-with-data-modelThis article will guide you through all issues about working with data models in EasyQuery library. How to load it from the DbContext or from your DB connection, or now to create a new one using Data Model Editor.
Setup custom value editor — WinForms
/how-to/custom-value-editor-winformsHere you can find all steps you need to perfom
JavaScript widgets formats and settings (MVC version)
/tutorials/javascript-widgets-settings-formatsIn this article, we describe the most common unique settings for EasyQuery JavaScript widgets and give examples of code.
Processing custom value editors in EasyQuery JS
/how-to/custom-value-editorHere you can find tips how to value editor setup and how to value editor widget
Processing custom value editors in EasyQuery JS
/how-to/processing-custom-value-editors-in-easyquery-jsFirst, 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.
Upgrading to 5.x: ASP.NET (MVC and WebForms) projects
/upgrade-instructions/net-framework-3-x-to-5-x-/asp-net-mvc-webformsThis tutorial describes how to upgrde your old ASP.NET MVC project with EasyQuery 3.x to EasyQuery version 5.2.0 (or higher). 1.2 Use NuGet Package Manager to install the following packages: Korzh.EasyQuery.AspNet4 Korzh.EasyQuery.EntityFramewok6 - if you are using Entity Framework 6.x Korzh.EasyQuery.DataExport - if you will need the data exporting functions Korzh.EasyQuery.MsSqlGate (or .MySqlGate or .OdbcGate depending on your DB) - if you need to load your model directly from DB connection. Finally, we need to make some modifications on our pages where we use EasyQuery scripts. Version 5.2.0 and higher of EasyQuery scripts will not need JQuery anymore, so you will be able to throw them away if they are not used in your own pages. Here is an example for "advanced search" view: To update your Web Forms page your will need to do the following 3 steps: Add EasyQuery scripts and styles on your page.