Show / Hide Table of Contents

Class TableExpression

TableExpression is the parent-class to the classes that work against tables. Subclasses will be Union, Differences and Intersections.

Inheritance
Object
SqlCommand
TableExpression
ActivityList.ActivityListQuery
RelationsList.RelationsListQuery
Difference
Intersect
Union
Inherited Members
SqlCommand.Origin
SqlCommand.AddIgnoreAutoSentryTableInfo(TableInfo)
SqlCommand.AddIgnoreAutoSentryTableInfo(IEnumerable<TableInfo>)
SqlCommand.RemoveIgnoreAutoSentryTableInfo(TableInfo)
SqlCommand.ClearIgnoreAutoSentryTableInfos()
SqlCommand.IsAutoSentryIgnoredOnTableInfo(TableInfo)
SqlCommand.GetPrivateSaves()
SqlCommand.GetInserts()
SqlCommand.GetUpdates()
SqlCommand.GetDeletes()
SqlCommand.GetSelect()
SqlCommand.SqlType
SqlCommand.AutoSentryIgnoredTables
Object.ToString()
Object.Equals(Object)
Object.Equals(Object, Object)
Object.ReferenceEquals(Object, Object)
Object.GetHashCode()
Object.GetType()
Object.MemberwiseClone()
Namespace: SuperOffice.Data.SQL
Assembly: SoDataBase.dll
Syntax
public abstract class TableExpression : SqlCommand

Constructors

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(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.

Overrides
SqlCommand.GetTableInfos()

Extension Methods

EnumUtil.MapEnums<From, To>(From)
QueryExectionExtensions.ExecuteReader(SqlCommand, Boolean)
QueryExectionExtensions.ExecuteScalar<T>(SqlCommand)
QueryExectionExtensions.ExecuteNonQuery(SqlCommand)
Converters.MapEnums<From, To>(From)
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top