Class Select

Class representing the SQL SELECT Statement

Inheritance
object
SqlCommand
PrivateSelect
Select
TargetedSelect<MainTableInfo>
Implements
Inherited Members
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

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

InnerOrderBy

Implementation of the OrderBy clause.

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

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

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

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

Extension Methods