8 results for "@tag:database"

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)

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

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.

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

Working with data model in EasyQuery

/getting-started/working-with-data-model

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

Exporting query results

/tutorials/exporting-query-results

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