13 results for "@tag:sql"

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)

Aggregate data

/tutorials/aggregate-data

From this article you will see how to aggregate (count, sum, etc.) data in your queries.

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.

Customizing common SQL clauses

/how-to/customizing-common-sql-clauses

This article is about settings for adding different options to the whole query (like DISTINCT, LIMIT, etc)

Date/time values formatting

/how-to/date-time-formatting

In this article, you can find instructions how to set up different types of date & time formats, with code examples.

Customizing SQL query formats

/how-to/customizing-sql-query-formats

Detailed instruction with various examples of how to operate with different query formats.

Simple query over one table

/tutorials/query-over-one-table

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

Upgrading from version 2.x to 3.0

/release-notes/upgrade-from-2.x-to-3.0

How to upgrade your project from version 2.x to version 3.0 of EasyQuery

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.

Value Editors

/data-model-editor/value-editors

Here you can find the full list of editors and choose any you need in your work with Data Model: