Class Select
Class representing the SQL SELECT Statement
Implements
Inherited Members
Namespace: SuperOffice.Data.SQL
Assembly: SoDataBase.dll
Syntax
public class Select : PrivateSelect, ICloneableProperties
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 |