C# Class Hd.QueryExtensions.FromTerm

显示文件 Open project: TargetProcess/Tp.HelpDesk Class Usage Examples

Public Methods

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

Method Details

FromTerm() public method

public FromTerm ( ) : System
return System

SubQuery() public static method

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

SubQuery() public static method

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

Table() public static method

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

Table() public static method

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

Table() public static method

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

Table() public static method

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

Table() public static method

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

TermRef() public static method

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