C# Class DbExpressions.DbSelectQueryExtensions

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

Mostra file Open project: seesharper/DbExpressions

Public Methods

Method	Description
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.

Method Details

GroupBy() public static method

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.
return	DbQuery

Having() public static method

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.
return	DbQuery

OrderBy() public static method

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.
return	DbQuery

OrderByAscending() public static method

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.
return	DbQuery

OrderByDescending() public static method

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.
return	DbQuery

Select() public static method

Specifies the projecton of the query.

public static Select ( this dbSelectQuery ) : DbSelectQuery
dbSelectQuery	this	The target
return	DbSelectQuery

Select() public static method

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.
return	DbSelectQuery

SelectDistinct() public static method

Specifies the projecton of the query.

public static SelectDistinct ( this dbSelectQuery ) : DbSelectQuery
dbSelectQuery	this	The target
return	DbSelectQuery

SelectDistinct() public static method

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.
return	DbSelectQuery

Skip() public static method

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.
return	DbQuery

Skip() public static method

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
return	DbQuery

Take() public static method

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.
return	DbQuery

Take() public static method

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.
return	DbQuery