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.

Inheritance
System.Object
JoinCompare
InnerJoin
LeftOuterJoin
RightOuterJoin
Implements
System.ICloneable
Namespace: SuperOffice.Data.SQL
Assembly: SoDataBase.dll
Syntax
public abstract class JoinCompare : Object, ICloneable

Constructors

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
System.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
System.String

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)