Show / Hide Table of Contents

Class Select

Class representing the SQL SELECT Statement

Inheritance
Object
SqlCommand
PrivateSelect
Select
TargetedSelect<MainTableInfo>
Implements
ICloneable
Inherited Members
PrivateSelect._isDistinct
PrivateSelect.GetTableInfos()
PrivateSelect.GetRelations(TableInfo)
PrivateSelect.GetRelations(TableInfo, SoTable)
PrivateSelect.IsTableOuterJoined(TableInfo)
PrivateSelect.GetTablesInOrderBy()
PrivateSelect.GetTablesLeadingToTable(TableInfo)
PrivateSelect.ValidateJoin()
PrivateSelect.Clone()
PrivateSelect.CloneSelect()
PrivateSelect.ToString()
PrivateSelect.GetCachingHash()
PrivateSelect.GetRestrictionTables()
PrivateSelect.CreateOrderBy()
PrivateSelect.IsDistinct
PrivateSelect.ForceRecompile
PrivateSelect.ForceJoinOrder
PrivateSelect.SqlType
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.AutoSentryIgnoredTables
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 class Select : PrivateSelect, ICloneable

Properties

GroupBy

Implementation of the GroupBy clause

Declaration
public GroupBy GroupBy { get; set; }
Property Value
Type Description
GroupBy

InnerGroupBy

Implementation of the Group by clause.

Declaration
protected override GroupBy InnerGroupBy { get; }
Property Value
Type Description
GroupBy
Overrides
PrivateSelect.InnerGroupBy

InnerJoinRestriction

Implementation of InnerJoinRestriction enabling the
SuperOffice.Data.Dialect to get the JoinRestriction object through the PrivateSelect class.

Declaration
protected override JoinRestriction InnerJoinRestriction { get; }
Property Value
Type Description
JoinRestriction
Overrides
PrivateSelect.InnerJoinRestriction

InnerOrderBy

Implementation of the OrderBy clause.

Declaration
protected override OrderBy InnerOrderBy { get; }
Property Value
Type Description
OrderBy
Overrides
PrivateSelect.InnerOrderBy

InnerRestriction

Implementation of InnerRestriction enabling the
SuperOffice.Data.Dialect to get the Restriction object through the PrivateSelect class.

Declaration
protected override Restriction InnerRestriction { get; }
Property Value
Type Description
Restriction
Overrides
PrivateSelect.InnerRestriction

InnerReturnFields

Implementation of InnerReturnFields enabling the SuperOffice.Data.Dialect to get the ReturnFields object through the PrivateSelect class

Declaration
protected override ReturnFieldsCollection InnerReturnFields { get; }
Property Value
Type Description
ReturnFieldsCollection
Overrides
PrivateSelect.InnerReturnFields

JoinRestriction

Join Restriction

Declaration
public JoinRestriction JoinRestriction { get; set; }
Property Value
Type Description
JoinRestriction

OrderBy

Implementation of the OrderBy clause.

Declaration
public OrderBy OrderBy { get; set; }
Property Value
Type Description
OrderBy

Restriction

Restriction, i.e., the WHERE clause of the query. To extend an existing restriction, use the RestrictionAnd(Restriction) and RestrictionOr(Restriction) methods.

Declaration
public Restriction Restriction { get; set; }
Property Value
Type Description
Restriction
Remarks

Note that restrictions on the outer table of an outer join should usually be added as part of the JOIN clause, as the outer join will otherwise collapse to an inner join (because the restriction is applied after the join has been performed, and any restriction is false when it meets a NULL result)

ReturnFields

FieldInfoCollection

Declaration
public ReturnFieldsCollection ReturnFields { get; set; }
Property Value
Type Description
ReturnFieldsCollection

The values the select-statement should return.

Methods

RestrictionAnd(Restriction)

Extend the current restriction with the given addition, placing an AND between them. If there is no current restriction, the addition becomes the current restriction.

Declaration
public void RestrictionAnd(Restriction additionalRestriction)
Parameters
Type Name Description
Restriction additionalRestriction

Additional restriction clause to add; may be null, in which case nothing happens

RestrictionOr(Restriction)

Extend the current restriction with the given addition, placing an OR between them. If there is no current restriction, the addition becomes the current restriction.

Declaration
public void RestrictionOr(Restriction additionalRestriction)
Parameters
Type Name Description
Restriction additionalRestriction

Additional restriction clause to add; may be null, in which case nothing happens

Implements

System.ICloneable

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