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