how-to/how-to/store-queries-in-a-database | EasyQuery.NET documentation

20 results for "how-to/how-to/store-queries-in-a-database"

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.

Generating queries for 2 (or more) databases

/how-to/querying-several-databases

Here you can find tricks for executing this task

How to save/load queries to/from database

/how-to/mvc-save-load-query-database

Find out how to change this default behavior and save/load queries to any other storage

obsolete version-3.x

Connect to your database

/getting-started/from-sample-to-your-own-project/connect-to-your-database

This article describes how to modify our sample project to make it work with your own database instead of Northwind DB used by default.

Query with OR operators

/tutorials/query-with-or-operators

In this article, you will learn how to build queries that contain both AND and OR operators.

query-example operator-or sql code-sample

Query with a subquery

/query-with-a-subquery

How to build queries with subqueries using EasyQuery.

data-model entity-framework query-sample subquery code-sample

Create a query with sub-query by code

/how-to/create-a-query-with-sub-query

Example with code

code code-sample sub-query data-model entity-framework

Common SQL queries

/tutorials/common-sql-queries

Query.Error class

/api-reference/korzh-easyquery/korzh-easyquery-namespace/query-error-class

Query exception class.

Query class

/api-reference-4x/korzh-easyquery-namespace/query-class

Represents internal query structure.

Query with table joins

/tutorials/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.

query-example sql table-join code-sample

Query class

/api-reference-5x/korzh-easyquery-namespace/query-class

Represents internal query structure.

Paging in query results

/tutorials/paging-in-query-results

Paging can make your work with query more convenient. And here is detailed instruction on how to use it.

paging dataset resultset code-sample

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

Query saving and loading

/tutorials/query-saving-and-loading

EasyQuery has built-in means for query saving and loading. Here we are going to describe the most common approaches for solving this task

Navigate through query conditions

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

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

api query conditions code-sample data-model

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

Exporting query results

/tutorials/exporting-query-results

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

query-result exporting data excel csv database code-sample

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

Localization of query builder's UI

/tutorials/query-builder-ui-localization

In this article, you can find two methods of localization of EasyQuery components

localization i18n code-sample