data-model-editor/tutorials/paging-in-query-results

In 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:

data-model operator entity attribute tables links connection

Previous versions' tutorials (obsolete)

/tutorials/version-3-x-tutorials

This section contains the tutorials that we written for older versions of EasyQuery and most probably are obsolete now.

Entities page

/data-model-editor/entities-page

This page describes entities participating in the data model and their attributes.

data-model entity-framework attributes

Value Editors

/data-model-editor/value-editors

Here you can find the full list of editors and choose any you need in your work with Data Model:

data-model dme sql query-panel value-editor

Operators page

/data-model-editor/operators-page

This article defines operators which can be used in conditions (such as 'is equal to', 'less than' and others).

data-model code-sample operators

Tables and links page

/data-model-editor/tables-links-page

Learn how to work with tables and links within your Data Model, change and edit them.

data-model tables links

Exporting query results

/tutorials/exporting-query-results

Detailed instruction on how to perform additional functionality while dealing with EasyQuery results.

query-result exporting data excel csv database code-sample

Aggregate data

/tutorials/aggregate-data

From this article you will see how to aggregate (count, sum, etc.) data in your queries.

query-example sql aggregate-function code-sample

Working with several data models

/tutorials/several-data-models

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

Query with a subquery

/query-with-a-subquery

How to build queries with subqueries using EasyQuery.

data-model entity-framework query-sample subquery code-sample

Query with OR operators

/tutorials/query-with-or-operators

In this article, you will learn how to build queries that contain both AND and OR operators.

query-example operator-or sql code-sample

Create a query with sub-query by code

/how-to/create-a-query-with-sub-query

Example with code

code code-sample sub-query data-model entity-framework

Possible ways of data model creation and loading

/tutorials/data-model-creation-loading

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

Common SQL queries

/tutorials/common-sql-queries