$s/use-cases/$s/@tag:table-join | EasyQuery.NET documentation

20 results for "$s/use-cases/$s/@tag:table-join"

Query with table joins

An example of query which require to define a table join(s) in case of using SQL. It's much more simple with EasyQuery.

Table class

/api-reference-4x/korzh-easyquery-db-namespace/table-class

Table class represents one table in a [Korzh.EasyQuery.Db.DbModel](api-reference-4x/korzh-easyquery-db-namespace/dbmodel-class) object

Table class

/api-reference-5x/korzh-easyquery-db-namespace/table-class

Table class represents one table in a [Korzh.EasyQuery.Db.DbModel](api-reference-5x/korzh-easyquery-db-namespace/dbmodel-class) object

Table class

/api-reference/korzh-easyquery-db/korzh-easyquery-db-namespace/table-class

Table class represents one table in a [Korzh.EasyQuery.Db.DbModel](api-reference/korzh-easyquery-db/korzh-easyquery-db-namespace/dbmodel-class) object

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

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.

data-model code-sample dme tables links

Simple query over one table

/tutorials/query-over-one-table

How to build a simple query with 1-2 conditions over one table (entity)

query-example sql table code-sample

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

Using parameters in query conditions

/how-to/parameters-in-query-conditions

This article explains how to work with parameterized conditions.

data-model asp-net asp-net-mvc parameters sql code-sample javascript

Using EqMvcDemoEF sample with your own DB context

/getting-started/sample-mvc-entity-framework-new-dbcontext

This article contains a brief instruction how to modify EqMvcDemoEF sample project to make it work with your own context class

asp-net mvc entity-framework dbcontext code-sample

Using MS SQL instead of Access in WebDemo sample project

/getting-started/sample-webforms-change-to-mssql

In this article, you will find the detailed instructions how to modify WebDemoCS or WebDemoAjaxCS to make it work with SQL Server instead of Access

asp-net webforms sql-server oledb code-sample

Building data model dynamically using code (version 3.x)

/how-to/build-data-model-by-code

Here you can find all steps you need to perform

data-model code-sample tables links connection

EasyQuery ASP.NET - using jQuery widgets on WebForms project

/getting-started/sample-webforms-javascript-webservice

In this article, you can find the instructions how to replace native WebForms with our jQuery widgets, with extract examples

asp-net webforms web-service javascript widgets code-sample

TableList class

/api-reference/korzh-easyquery-db/korzh-easyquery-db-namespace/tablelist-class

Represents list of the [Korzh.EasyQuery.Db.Table](api-reference/korzh-easyquery-db/korzh-easyquery-db-namespace/table-class) objects.

TableList class

/api-reference-5x/korzh-easyquery-db-namespace/tablelist-class

Represents list of the [Korzh.EasyQuery.Db.Table](api-reference-5x/korzh-easyquery-db-namespace/table-class) objects.

TableList class

/api-reference-4x/korzh-easyquery-db-namespace/tablelist-class

Represents list of the [Korzh.EasyQuery.Db.Table](api-reference-4x/korzh-easyquery-db-namespace/table-class) objects.

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

Version 5.3 + EasyQuery.JS 6.0 release notes

/release-notes/version-5-3

The biggest change in this release is a new major update (version 6.0) of JavaScript library (EasyQuery.JS) used with ASP.NET or ASP.NET Core editions of EasyQuery. Version 5.3 of EasyQuery contains rather small improvements in the core libraries and all .NET editions. Community edition packages include @easyquery/core , @easyquery/ui . All license owners of EasyQuery for ASP.NET or EasyQuery for ASP.NET Core automatically got a license for EasyQuery.JS as well. to set your key, now for ASP.NET Core edition it will be Respectively, you should use Korzh.EasyQuery.AspNet...

DbModel class

/api-reference-5x/korzh-easyquery-db-namespace/dbmodel-class

Database-related implementation of [Korzh.EasyQuery.DataModel](api-reference-5x/korzh-easyquery-namespace/datamodel-class) class. In addition to the basic data it contains also list of database tables and the links between them.

DbTable class

/api-reference-5x/korzh-easyquery-db-namespace/dbtable-class

Represents one table in [Korzh.EasyQuery.Db.DbModel](api-reference-5x/korzh-easyquery-db-namespace/dbmodel-class) object which corresponds to some database table