EntitySqlQueryExtensions class

namespace: Serenity.Data assembly: Serenity.Net.Entity

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 target for future field selections.
static GroupBy(…)	Adds fields expressions to group by list (2 methods)
static Into(…)	Add the specified entity to INTO list of the query, and sets it as current INTO row.
static OrderBy(…)	Adds fields expression to 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 field's entity class, it is automatically included in the query. The field is marked as a target at 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 current index for future loading from a data reader.