13 results for "@tag:sql"

Building 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


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

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


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

Date/time values 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


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

Simple 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


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

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


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