C# 클래스 Serenity.Data.EntitySqlQueryExtensions

Extensions for SqlQuery.

공개 메소드들

메소드	설명
From ( this query, IEntity entity ) : SqlQuery	Adds a table to the FROM statement with "T0" alias and sets it as target for future field selections.
GroupBy ( this query ) : SqlQuery
GroupBy ( this query, IField field ) : SqlQuery
Into ( this query, IEntity into ) : SqlQuery
OrderBy ( this query ) : SqlQuery
OrderBy ( this query, IField field, bool desc = false ) : SqlQuery
Select ( this query ) : SqlQuery	For each field in the fields array, adds expression of the field to the SELECT statement with a column name of its 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 fields are marked as a target at current index for future loading from a data reader.
Select ( this query, IAlias alias, IField field ) : SqlQuery	Adds a field of a given table alias to the SELECT statement. No column name is set for the selected field. Also field is not set as a target, unlike field only overload, only field name is used.
Select ( this query, IAlias alias, IField field, string columnName ) : SqlQuery	Adds a field of a given table alias to the SELECT statement. Field is not set as a target, unlike field only overload, only field name is used.
Select ( this query, IField field ) : SqlQuery	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.
Select ( this query, IField field, string columnName ) : SqlQuery	Adds a field's expression to the SELECT statement with a given 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.
SelectAs ( this query, string expression, IField intoField ) : SqlQuery	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.

메소드 상세

From() 공개 정적인 메소드

Adds a table to the FROM statement with "T0" alias and sets it as target for future field selections.

public static From ( this query, IEntity entity ) : SqlQuery
query	this
entity	IEntity
리턴	SqlQuery

GroupBy() 공개 정적인 메소드

public static GroupBy ( this query ) : SqlQuery
query	this
리턴	SqlQuery

GroupBy() 공개 정적인 메소드

public static GroupBy ( this query, IField field ) : SqlQuery
query	this
field	IField
리턴	SqlQuery

Into() 공개 정적인 메소드

public static Into ( this query, IEntity into ) : SqlQuery
query	this
into	IEntity
리턴	SqlQuery

OrderBy() 공개 정적인 메소드

public static OrderBy ( this query ) : SqlQuery
query	this
리턴	SqlQuery

OrderBy() 공개 정적인 메소드

public static OrderBy ( this query, IField field, bool desc = false ) : SqlQuery
query	this
field	IField
desc	bool
리턴	SqlQuery

Select() 공개 정적인 메소드

For each field in the fields array, adds expression of the field to the SELECT statement with a column name of its 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 fields are marked as a target at current index for future loading from a data reader.

public static Select ( this query ) : SqlQuery
query	this
리턴	SqlQuery

Select() 공개 정적인 메소드

Adds a field of a given table alias to the SELECT statement.

No column name is set for the selected field. Also field is not set as a target, unlike field only overload, only field name is used.

public static Select ( this query, IAlias alias, IField field ) : SqlQuery
query	this
alias	IAlias	A table alias that will be prepended to the field name with "." between
field	IField	A field that only name will be used. It won't be set as a target.
리턴	SqlQuery

Select() 공개 정적인 메소드

Adds a field of a given table alias to the SELECT statement.

Field is not set as a target, unlike field only overload, only field name is used.

public static Select ( this query, IAlias alias, IField field, string columnName ) : SqlQuery
query	this
alias	IAlias	A table alias that will be prepended to the field name with "." between
field	IField	A field that only its field name will be used. It won't be set as a target.
columnName	string	A column name
리턴	SqlQuery

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.

public static Select ( this query, IField field ) : SqlQuery
query	this
field	IField	Field object
리턴	SqlQuery

Select() 공개 정적인 메소드

Adds a field's expression to the SELECT statement with a given 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.

public static Select ( this query, IField field, string columnName ) : SqlQuery
query	this
field	IField	Field object
columnName	string
리턴	SqlQuery

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.

public static SelectAs ( this query, string expression, IField intoField ) : SqlQuery
query	this
expression	string	A field name or an expression
intoField	IField	A field object whose name to be used as a column name.
리턴	SqlQuery