Class TableExpression
TableExpression is the parent-class to the classes that work against tables. Subclasses will be Union, Differences and Intersections.
Inheritance
TableExpression
Inherited Members
Namespace: SuperOffice.Data.SQL
Assembly: SoDataBase.dll
Syntax
public abstract class TableExpression : SqlCommandConstructors
TableExpression()
Initializes a new instance of the TableExpression class.
Declaration
protected TableExpression()Properties
TableExp
Get/Set method for the expression.
Declaration
public List<Select> TableExp { get; set; }Property Value
| Type | Description |
|---|---|
| List<Select> |
TableExpOrderBy
Get/Set method for the OrderBy-clause of the expression.
Declaration
public OrderBy TableExpOrderBy { get; set; }Property Value
| Type | Description |
|---|---|
| OrderBy |
Methods
Add(params Select[])
Add( params Select[] arg ) will add the necessary select-query to the _tableExpression array list and keep them until they've been parsed to sql-queries.
Declaration
public void Add(params Select[] arg)Parameters
| Type | Name | Description |
|---|---|---|
| Select[] | arg | The Select-query we want to add a tableexpression on. |
GetTableInfos()
Obtain a list of all tables involved in the expression.
Declaration
public override TableInfo[] GetTableInfos()Returns
| Type | Description |
|---|---|
| TableInfo[] | List of all tables involved in the expression. |