EntitySqlQueryExtensions class

namespace: Serenity.Data assembly: Serenity.Net.Services

Extensions for SqlQuery.

public static class EntitySqlQueryExtensions

Public Members

name	description
static From(…)	Adds a table to the FROM statement with "T0" alias and sets it as the target for future field selections.
static GroupBy(…)	Adds a field's expression to the group by list. (2 methods)
static Into(…)	Adds the specified entity to the INTO list of the query, and sets it as the current INTO row.
static OrderBy(…)	Adds a field's expression to the order by list. (2 methods)
static Select(…)	Adds a field's expression to the SELECT statement with its own column name. If a join alias is referenced in the field expression, and the join is defined in the field's entity class, it is automatically included in the query. The field is marked as a target at the current index for future loading from a data reader. (5 methods)
static SelectAs(…)	Adds a field or an expression to the SELECT statement with a column name of a field's name. The field is marked as a target at the current index for future loading from a data reader.