Hide some entities and/or attributes
/how-to/hide-entities-and-attributesHere we explain how to implement different ways to limit the quantity of entities and attributes shown in Data Model
Create virtual (calculated) attribute in you model
/tutorials/add-virtual-attribute-in-modelVirtual attributes: what are they for and how to add one
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
Using parameters in query conditions
/how-to/parameters-in-query-conditionsThis article explains how to work with parameterized conditions.
Using EqMvcDemoEF sample with your own DB context
/getting-started/sample-mvc-entity-framework-new-dbcontextThis article contains a brief instruction how to modify EqMvcDemoEF sample project to make it work with your own context class
How to add a column with the same attribute as in newly added condition
/how-to/add-column-by-condition-attributeA code snippet which demonstrates how to do this task
Using MS SQL instead of Access in WebDemo sample project
/getting-started/sample-webforms-change-to-mssqlIn this article, you will find the detailed instructions how to modify WebDemoCS or WebDemoAjaxCS to make it work with SQL Server instead of Access
Building data model dynamically using code (version 3.x)
/how-to/build-data-model-by-codeHere you can find all steps you need to perform
EasyQuery ASP.NET - using jQuery widgets on WebForms project
/getting-started/sample-webforms-javascript-webserviceIn this article, you can find the instructions how to replace native WebForms with our jQuery widgets, with extract examples
EntityAttr class
/api-reference-5x/korzh-easyquery-namespace/entityattr-classRepresents one entity attribute of data model.
Entities page
/data-model-editor/entities-pageThis page describes entities participating in the data model and their attributes.
EntityAttr class
/api-reference-4x/korzh-easyquery-namespace/entityattr-classRepresents one entity attribute of data model.
MetaEntityAttr class
/api-reference/easydata-core/easydata-namespace/metaentityattr-classRepresents one entity attribute of data model.
EntityAttr class
/api-reference/korzh-easyquery/korzh-easyquery-namespace/entityattr-classRepresents one entity attribute of data model.
DbEntityAttr class
/api-reference-5x/korzh-easyquery-db-namespace/dbentityattr-classBase attribute of SQL entity
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:
DbEntityAttr class
/api-reference-4x/korzh-easyquery-db-namespace/dbentityattr-classBase attribute of SQL entity
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.
Lookup fields and columns
/tutorials/lookup-fields-columnsHow to deal with lookup fields in EasyQuery