C# 클래스 Hd.QueryExtensions.FromTerm

파일 보기 프로젝트 열기: TargetProcess/Tp.HelpDesk 1 사용 예제들

공개 메소드들

메소드 설명
FromTerm ( ) : System
SubQuery ( SelectQuery query, string alias ) : FromTerm

Creates a FromTerm which represents a sub-query.

SubQuery ( string query, string alias ) : FromTerm

Creates a FromTerm which represents a sub-query.

Table ( Enum tableName, string alias ) : FromTerm
Table ( string name ) : FromTerm

Creates a FromTerm which represents a database table or view.

Creates a FromTerm without an alias. The created term will be referenced by the table's name.

Table ( string tableName, string alias ) : FromTerm

Creates a FromTerm which represents a database table or view.

Table ( string tableName, string alias, string ns ) : FromTerm

Creates a FromTerm which represents a database table or view.

Use the ns parameter to resolve table ownership

Table ( string tableName, string alias, string ns1, string ns2 ) : FromTerm

Creates a FromTerm which represents a database table or view.

Use the ns1 parameter to set table database and ns2 to set table owner.

TermRef ( string name ) : FromTerm

Creates a FromTerm which refernces abother FromTerm.

Use TermRef to reference other terms of a from clause by RefName

메소드 상세

FromTerm() 공개 메소드

public FromTerm ( ) : System
리턴 System

SubQuery() 공개 정적인 메소드

Creates a FromTerm which represents a sub-query.
public static SubQuery ( SelectQuery query, string alias ) : FromTerm
query SelectQuery A SelectQuery instance representing the sub query
alias string term alias
리턴 FromTerm

SubQuery() 공개 정적인 메소드

Creates a FromTerm which represents a sub-query.
public static SubQuery ( string query, string alias ) : FromTerm
query string sub-query sql
alias string term alias
리턴 FromTerm

Table() 공개 정적인 메소드

public static Table ( Enum tableName, string alias ) : FromTerm
tableName System.Enum
alias string
리턴 FromTerm

Table() 공개 정적인 메소드

Creates a FromTerm which represents a database table or view.
Creates a FromTerm without an alias. The created term will be referenced by the table's name.
public static Table ( string name ) : FromTerm
name string Name of the table or view
리턴 FromTerm

Table() 공개 정적인 메소드

Creates a FromTerm which represents a database table or view.
public static Table ( string tableName, string alias ) : FromTerm
tableName string Name of the table or view
alias string Alias of the FromTerm
리턴 FromTerm

Table() 공개 정적인 메소드

Creates a FromTerm which represents a database table or view.
Use the ns parameter to resolve table ownership
public static Table ( string tableName, string alias, string ns ) : FromTerm
tableName string Name of the table or view
alias string Alias of the FromTerm
ns string Namespace of the table.
리턴 FromTerm

Table() 공개 정적인 메소드

Creates a FromTerm which represents a database table or view.
Use the ns1 parameter to set table database and ns2 to set table owner.
public static Table ( string tableName, string alias, string ns1, string ns2 ) : FromTerm
tableName string Name of the table or view
alias string Alias of the FromTerm
ns1 string First table namespace
ns2 string Second table namespace
리턴 FromTerm

TermRef() 공개 정적인 메소드

Creates a FromTerm which refernces abother FromTerm.
Use TermRef to reference other terms of a from clause by RefName
public static TermRef ( string name ) : FromTerm
name string The name of the referenced term.
리턴 FromTerm