Specifies the operation to use when comparing the constituents of a SQL join operation (the constituents of the ON clause in a SQL statement).

This class is used by SearchSQL.SetFromClauseAdditionalJoin to construct a join.


The following tables list the members exposed by JoinComparison.

Protected Constructors

 NameDescription
Family methodJoinComparison 
Top

Public Fields

 NameDescription
Public fieldStaticEQUALA constant representing a JoinComparison instance of type EQUAL. This specifies that the constituents of the join are equal. This field is read-only.
Public fieldStaticEQUAL_AS_INTAn integer associated with the EQUAL instance of this class. Use the static instances of this class, rather than the associated integer values. The integer values risk binary incompatibility (but not source incompatibility) across product releases. This field is constant and read-only.
Public fieldStaticGREATER_THANA constant representing a JoinComparison instance of type GREATER_THAN. This specifies that the initial constituent of the join is greater than the other constituent. This field is read-only.
Public fieldStaticGREATER_THAN_AS_INTAn integer associated with the GREATER_THAN instance of this class. Use the static instances of this class, rather than the associated integer values. The integer values risk binary incompatibility (but not source incompatibility) across product releases. This field is constant and read-only.
Public fieldStaticGREATER_THAN_EQUAL_TOA constant representing a JoinComparison instance of type GREATER_THAN_EQUAL_TO. This specifies that the initial constituent of the join is greater than or equal to the other constituent. This field is read-only.
Public fieldStaticGREATER_THAN_EQUAL_TO_AS_INTAn integer associated with the GREATER_THAN_EQUAL_TO instance of this class. Use the static instances of this class, rather than the associated integer values. The integer values risk binary incompatibility (but not source incompatibility) across product releases. This field is constant and read-only.
Public fieldStaticLESS_THANA constant representing a JoinComparison instance of type LESS_THAN. This specifies that the initial constituent of the join is less than the other constituent. This field is read-only.
Public fieldStaticLESS_THAN_AS_INTAn integer associated with the LESS_THAN instance of this class. Use the static instances of this class, rather than the associated integer values. The integer values risk binary incompatibility (but not source incompatibility) across product releases. This field is constant and read-only.
Public fieldStaticLESS_THAN_EQUAL_TOA constant representing a JoinComparison instance of type LESS_THAN_EQUAL_TO. This specifies that the initial constituent of the join is less than or equal to the other constituent. This field is read-only.
Public fieldStaticLESS_THAN_EQUAL_TO_AS_INTAn integer associated with the LESS_THAN_EQUAL_TO instance of this class. Use the static instances of this class, rather than the associated integer values. The integer values risk binary incompatibility (but not source incompatibility) across product releases. This field is constant and read-only.
Public fieldStaticNOT_EQUALA constant representing a JoinComparison instance of type NOT_EQUAL. This specifies that the constituents of the join are not equal. This field is read-only.
Public fieldStaticNOT_EQUAL_AS_INTAn integer associated with the NOT_EQUAL instance of this class. Use the static instances of this class, rather than the associated integer values. The integer values risk binary incompatibility (but not source incompatibility) across product releases. This field is constant and read-only.
Top

Public Methods

 NameDescription
Public methodEqualsOverridden.  
Public methodGetHashCodeOverridden.  
Public methodStaticGetInstanceFromIntGets an instance of this class using its associated integer value (the *_AS_INT fields).
Public methodGetObjectData******************************************************** * * Object Serialization * **********************************************************
Public methodGetOperatorGets the standard string representation of the comparison operator used by this instance.

The operators returned will be one of the following (shown with their corresponding field):

  • "equal to" character, (EQUAL_AS_INT)
  • "less than" and "greater than" characters, (NOT_EQUAL_AS_INT)
  • "less than" character, (LESS_THAN_AS_INT)
  • "greater than" character, (GREATER_THAN_AS_INT)
  • "less than" and "equal to" characters, (LESS_THAN_EQUAL_TO_AS_INT)
  • "greater than" and "equal to" characters, (GREATER_THAN_EQUAL_TO_AS_INT)
Public methodGetTypeGets the Type of the current instance. (inherited from Object)
Public methodGetValueReturns an integer value associated with a specific instance of this class.
Public methodToStringOverridden. Returns a String representation of this instance.
Top

Protected Methods

 NameDescription
Family methodFinalizeAllows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (inherited from Object)
Family methodMemberwiseCloneCreates a shallow copy of the current Object. (inherited from Object)
Top

See Also