$s/end-user-guide | EasyQuery.NET documentation

20 results for "$s/end-user-guide"

Back to articles

End-user's guide

/end-user-guide

1. EasyQuery: What’s That?

User-friendly name for tables

/how-to/user-friendly-name-for-tables

Some tips for choosing right “entities” and their “attributes”

data-model entity-framework attributes ui connection tables fields

How to restrict access to EasyQuery middleware for non-authenticated users

/how-to/easyquery-middleware-non-authenticated-users

Problem Your web application has an open part (main page, some info pages, login/registration forms) and the part that requires the authorization. And you want that the data-filtering or ad-hoc reporting functionality provided by EasyQuery be available only for authorized users. Solution Starting from version 5

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:

data-model operator entity attribute tables links connection

Introduction

/introduction

If in short, EasyQuery - set of components that allow you (as a developer) to implement a functional, user-friendly query builder in your application

query-builder adhoc-reporting data-filtering advanced-data-search

DefaultEqAuthProvider class

/api-reference/korzh-easyquery-aspnetcore/korzh-easyquery-services-namespace/defaulteqauthprovider-class

The default implementation of the [Korzh.EasyQuery.Services.IEqAuthProvider](api-reference/korzh-easyquery/korzh-easyquery-services-namespace/ieqauthprovider-interface) interface. Contains several methods which allow to mark some EasyQuery actions as "anonymous" (so they can be accessed by any user) and to restrict the access to them depening on user role.

How to add an extra condition to your query

/how-to/add-extra-condition

Two possible ways of resolving this task

code-sample entity-framework data-model sql query-builder conditions

DefaultEqAuthProvider class

/api-reference-5x/korzh-easyquery-services-namespace/defaulteqauthprovider-class

The default implementation of the [Korzh.EasyQuery.Services.IEqAuthProvider](api-reference-5x/korzh-easyquery-services-namespace/ieqauthprovider-interface) interface. Contains several methods which allow to mark some EasyQuery actions as "anonymous" (so they can be accessed by any user) and to restrict the access to them depening on user role.

Store queries in a database

/how-to/store-queries-in-a-database

Here we describe the case when all users of some web application create their own queries and would like to store those queries in some database.

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.

data-model dme database

Entities page

/data-model-editor/entities-page

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

data-model entity-framework attributes

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

data-model database connection widgets controls query-builder

ColumnsPanelEditMode enum

/api-reference/korzh-easyquery-winforms/korzh-easyquery-winforms-namespace/columnspaneleditmode-enum

Represents different types of modifications in query columns panel available for users.

ColumnsPanel.EditModeKind enum

/api-reference/korzh-easyquery-wpf/korzh-easyquery-wpf-namespace/columnspanel-editmodekind-enum

Represents different types of modifications in query columns panel available for users.

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'")

data-model database entity operator attribute value-editor