49 results for "@tag:data-model"

Data Model

/fundamentals/data-model

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:

Building dynamic queries with EasyQuery and Entity Framework

/tutorials/dynamic-queries-with-easyquery-and-entity-framework

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)

Introduction to value editors

/fundamentals/about-data-editors

Each condition in query consists of 3 parts: attribute (field), operator and values (one or more). By default when a user clicks on ”[enter value]” link in a condition he/she is presented with an edit box actually to type the value. EasyQuery allows you to assign a value editor for each attribute or operator in your model - so your users will be able to use other methods of entering values

Entities page

/data-model-editor/entities-page

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

Processing custom value editors in EasyQuery JS

/how-to/custom-value-editor

Here you can find tips how to value editor setup and how to value editor widget

How it works

/fundamentals/how-it-works

The above scheme shows the general internal structure of the library and the main principles of its work. EasyQuery components All EasyQuery classes and components can be divided into two main parts: logical part (DataModel, Query, SqlQueryBuilder). the visual part (QueryPanel, ColumnsPanel, etc.). The logical part is responsible for the internal representation of data structures and user

Edit link dialog

/data-model-editor/edit-link-dialog

Here you can find all necessary information of how to edit link dialog and how to add new conditions.

Getting started for EasyQuery ASP.NET MVC

/getting-started/asp-net-mvc

This article will guide you through all steps necessary to apply EasyQuery ASP.NET to MVC web application

Customizing SQL query formats

/how-to/customizing-sql-query-formats

Detailed instruction with various examples of how to operate with different query formats.

Navigate through query conditions

/how-to/run-through-query-conditions

A code snippet which demonstrates how to run through all conditions in your query

Building data model dynamically by DB meta-information

/how-to/build-data-model-by-db-meta-information

It's easier to fill your model right in the code directly from your database, using meta-information

Getting started for ASP.NET WebForms

/getting-started/asp-net-webforms

Here you can find the instructions how to add EasyQuery components into your ASP.NET WebForms project

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

Hide some entities and/or attributes

/how-to/hide-entities-and-attributes

Here we explain how to implement different ways to limit the quantity of entities and attributes shown in Data Model

Add a new aggregate function

/how-to/add-aggregate-function

EasyQuery allows to add new aggregate functions for user's need. Here is detailed manual of how to do it with code example.

Terminology

/fundamentals/terminology

Common terms Database - may refer to any data storage but in most cases we mean some relational database such as MS SQL Server, My SQL, Oracle, etc. Result set - a result of some search request (query). Usually, is presented as tabular data. Query - a search request. Query condition - one of the search terms (for example: "Customer name starts with 'A'")

About Data Model Editor

/data-model-editor/about

Here you can find detailed information about this instrument and guideline, how to use it to perform all needed tasks.

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.

Upgrading from version 2.x to 3.0

/release-notes/upgrade-from-2.x-to-3.0

How to upgrade your project from version 2.x to version 3.0 of EasyQuery

How to limit columns from duplication

/how-to/how-to-limit-columns-from-duplication

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.

How to show descriptive texts in some column instead of numeric values

/how-to/descriptive-texts-in-column-instead-numeric-values

How to show some descriptive texts for some column in result set instead of actual numeric values stored in DB

Creating new data model using Data Model Editor

/getting-started/new-data-model

This article will guide you through all steps necessary to create your first data model based on your database.

Navigate through data model entities and attributes

/how-to/run-through-data-model-entities

A code snippet which demonstrates how to run through data model entities and attributes

How to make field to field comparison

/how-to/field-to-field-comparison

The instructions on how to add a condition which compares a field against another field instead of constant value.

Working with table aliases

/data-model-editor/working-with-aliases

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.

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:

Getting started for Silverlight

/getting-started/silverlight

This article will guide you through all steps necessary to apply EasyQuery.NET to your application, with extract examples

Getting started for WPF

/getting-started/wpf

You will be able to apply EasyQuery WPF to your application, performing all the instructions in this article