C# Класс DbExpressions.DbSelectQueryExtensions

Provides the fluent interface that targets a 'SELECT' query.

Открытые методы

Метод	Описание
GroupBy ( this dbSelectQuery, DbExpression>.Func expressionSelector ) : DbQuery	Collects data across multiple records and group the results by one or more columns.
Having ( this dbSelectQuery, DbExpression>.Func expressionSelector ) : DbQuery	Specifies a search condition for a group or an aggregate.
OrderBy ( this dbSelectQuery, DbExpression>.Func expressionSelector, DbOrderByExpressionType orderByExpressionType ) : DbQuery	Creates a DbOrderByExpression that represents ordering the result set.
OrderByAscending ( this dbSelectQuery, DbExpression>.Func expressionSelector ) : DbQuery	Creates a new DbOrderByExpression that represents an ascending ordering of the result set.
OrderByDescending ( this dbSelectQuery, DbExpression>.Func expressionSelector ) : DbQuery	Creates a new DbOrderByExpression that represents an descending ordering of the result set.
Select ( this dbSelectQuery ) : DbSelectQuery	Specifies the projecton of the query.
Select ( this dbSelectQuery, DbExpression expression ) : DbSelectQuery	Specifies the projection of the query.
SelectDistinct ( this dbSelectQuery ) : DbSelectQuery	Specifies the projecton of the query.
SelectDistinct ( this dbSelectQuery, DbExpression expression ) : DbSelectQuery	Specifies the projection of the query.
Skip ( this dbSelectQuery, DbExpression>.Func expressionSelector ) : DbQuery	Bypasses a specified number of rows in the result set.
Skip ( this dbSelectQuery, int count ) : DbQuery	Bypasses a specified number of rows in the result set.
Take ( this dbSelectQuery, DbExpression>.Func expressionSelector ) : DbQuery	Limits the numbers of rows returned by the query.
Take ( this dbSelectQuery, int count ) : DbQuery	Limits the numbers of rows returned by the query.

Описание методов

GroupBy() публичный статический Метод

Collects data across multiple records and group the results by one or more columns.

public static GroupBy ( this dbSelectQuery, DbExpression>.Func expressionSelector ) : DbQuery
dbSelectQuery	this	The target .
expressionSelector	DbExpression>.Func	A function used to specify an element in the 'GROUP BY' clause.
Результат	DbQuery

Having() публичный статический Метод

Specifies a search condition for a group or an aggregate.

public static Having ( this dbSelectQuery, DbExpression>.Func expressionSelector ) : DbQuery
dbSelectQuery	this	The target .
expressionSelector	DbExpression>.Func	A function used to specify the 'HAVING' expression.
Результат	DbQuery

OrderBy() публичный статический Метод

Creates a DbOrderByExpression that represents ordering the result set.

public static OrderBy ( this dbSelectQuery, DbExpression>.Func expressionSelector, DbOrderByExpressionType orderByExpressionType ) : DbQuery
dbSelectQuery	this	The target .
expressionSelector	DbExpression>.Func	A function used to specify an element in the 'ORDER BY' clause.
orderByExpressionType	DbOrderByExpressionType	Specifies the sort order direction.
Результат	DbQuery

OrderByAscending() публичный статический Метод

Creates a new DbOrderByExpression that represents an ascending ordering of the result set.

public static OrderByAscending ( this dbSelectQuery, DbExpression>.Func expressionSelector ) : DbQuery
dbSelectQuery	this	The target .
expressionSelector	DbExpression>.Func	A function used to specify an element in the 'ORDER BY' clause.
Результат	DbQuery

OrderByDescending() публичный статический Метод

Creates a new DbOrderByExpression that represents an descending ordering of the result set.

public static OrderByDescending ( this dbSelectQuery, DbExpression>.Func expressionSelector ) : DbQuery
dbSelectQuery	this	The target .
expressionSelector	DbExpression>.Func	A function used to specify an element in the 'ORDER BY' clause.
Результат	DbQuery

Select() публичный статический Метод

Specifies the projecton of the query.

public static Select ( this dbSelectQuery ) : DbSelectQuery
dbSelectQuery	this	The target
Результат	DbSelectQuery

Select() публичный статический Метод

Specifies the projection of the query.

public static Select ( this dbSelectQuery, DbExpression expression ) : DbSelectQuery
dbSelectQuery	this	The target
expression	DbExpression	The that represents the projection.
Результат	DbSelectQuery

SelectDistinct() публичный статический Метод

Specifies the projecton of the query.

public static SelectDistinct ( this dbSelectQuery ) : DbSelectQuery
dbSelectQuery	this	The target
Результат	DbSelectQuery

SelectDistinct() публичный статический Метод

Specifies the projection of the query.

public static SelectDistinct ( this dbSelectQuery, DbExpression expression ) : DbSelectQuery
dbSelectQuery	this	The target
expression	DbExpression	The that represents the projection.
Результат	DbSelectQuery

Skip() публичный статический Метод

Bypasses a specified number of rows in the result set.

public static Skip ( this dbSelectQuery, DbExpression>.Func expressionSelector ) : DbQuery
dbSelectQuery	this	The target .
expressionSelector	DbExpression>.Func	A function used to create a that the number of rows to bypass.
Результат	DbQuery

Skip() публичный статический Метод

Bypasses a specified number of rows in the result set.

public static Skip ( this dbSelectQuery, int count ) : DbQuery
dbSelectQuery	this	The target .
count	int	The number of rows to bypass in the result set
Результат	DbQuery

Take() публичный статический Метод

Limits the numbers of rows returned by the query.

public static Take ( this dbSelectQuery, DbExpression>.Func expressionSelector ) : DbQuery
dbSelectQuery	this	The target .
expressionSelector	DbExpression>.Func	A function used to create a that the number of rows to return.
Результат	DbQuery

Take() публичный статический Метод

Limits the numbers of rows returned by the query.

public static Take ( this dbSelectQuery, int count ) : DbQuery
dbSelectQuery	this	The target .
count	int	The number of rows to return.
Результат	DbQuery