Class JoinCompare
This class represents a join, consisting of a) a mandatory Equal comparison that defines the join, and b) an optional, arbitrarily deep Restriction that contains additional restrictions to be part of the join clause. Concrete subclasses then define if this is an Inner, Left Outer or Right Outer join.
Implements
Inherited Members
Namespace: SuperOffice.Data.SQL
Assembly: SoDataBase.dll
Syntax
public abstract class JoinCompare : ICloneableConstructors
JoinCompare(Equal)
Initializes a new instance of the JoinCompare class and takes a Compare and Restriction as in-parameter. Takes a Compare as in-parameter, for example field = field.
Declaration
protected JoinCompare(Equal comp)Parameters
| Type | Name | Description |
|---|---|---|
| Equal | comp | The Compare-parameter. |
JoinCompare(Equal, Restriction)
Initializes a new instance of the JoinCompare class and takes a Compare and Restriction as in-parameter.
Declaration
protected JoinCompare(Equal comp, Restriction res)Parameters
| Type | Name | Description |
|---|---|---|
| Equal | comp | The Compare-parameter. |
| Restriction | res | The Restriction-parameter, nulls are now allowed |
Properties
Compare
Gets the compare part of the join.
Declaration
public Equal Compare { get; set; }Property Value
| Type | Description |
|---|---|
| Equal |
Restriction
Get or set the restriction part of the join.
Declaration
public Restriction Restriction { get; set; }Property Value
| Type | Description |
|---|---|
| Restriction |
Methods
Clone()
ICloneable stub.
Declaration
public abstract object Clone()Returns
| Type | Description |
|---|---|
| Object | A new object that is a copy of this instance. |
RestrictionAnd(Restriction)
Declaration
public void RestrictionAnd(Restriction additional)Parameters
| Type | Name | Description |
|---|---|---|
| Restriction | additional |
RestrictionOr(Restriction)
Declaration
public void RestrictionOr(Restriction additional)Parameters
| Type | Name | Description |
|---|---|---|
| Restriction | additional |
ToString()
Declaration
public override string ToString()Returns
| Type | Description |
|---|---|
| String |