C# Class Hd.QueryExtensions.FromTerm

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

public FromTerm ( ) : System
return	System

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

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

public static Table ( Enum tableName, string alias ) : FromTerm
tableName	System.Enum
alias	string
return	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.

public static Table ( string name ) : FromTerm
name	string	Name of the table or view
return	FromTerm

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

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

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

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