Share via

SetJoinTable Method (String, String, String, CatalogJoinType)

  • Article

Set the default JoinTableInformation information for this catalog context.

Namespace:  Microsoft.CommerceServer.Catalog
Assembly:  Microsoft.CommerceServer.Catalog (in Microsoft.CommerceServer.Catalog.dll)

Syntax

'Declaration
Public Sub SetJoinTable ( _
    targetTableName As String, _
    sourceJoinKey As String, _
    targetJoinKey As String, _
    joinType As CatalogJoinType _
)

'Usage
Dim instance As CatalogContext
Dim targetTableName As String
Dim sourceJoinKey As String
Dim targetJoinKey As String
Dim joinType As CatalogJoinType

instance.SetJoinTable(targetTableName, _
    sourceJoinKey, targetJoinKey, joinType)

public void SetJoinTable(
    string targetTableName,
    string sourceJoinKey,
    string targetJoinKey,
    CatalogJoinType joinType
)

public:
void SetJoinTable(
    String^ targetTableName, 
    String^ sourceJoinKey, 
    String^ targetJoinKey, 
    CatalogJoinType joinType
)

public function SetJoinTable(
    targetTableName : String, 
    sourceJoinKey : String, 
    targetJoinKey : String, 
    joinType : CatalogJoinType
)

Parameters

  • targetTableName
    Type: System..::.String
    The name of the target (external) table to use.

Remarks

The join table stores join information about an external data table or view that is joined to the catalog system. The information is for joining product/variant records. The join information is in effect for the lifetime of the CatalogContext object.

The joinType enumeration is a value to specify the type of join to use across the catalog system.

Member

Value

Description

InnerJoin

0

Return only those rows where the keys are equal.

OuterJoinLeft

1

Return all rows in the Product Catalog System and only the matching rows in the target table.

OuterJoinRight

2

Return only matching rows in the Product Catalog System and all rows in the target table.

OuterJoinFull

3

Return all rows in both tables.

NoJoin

-1

Reserved for future use.

Permissions

See Also

Reference

CatalogContext Class

CatalogContext Members

SetJoinTable Overload

Microsoft.CommerceServer.Catalog Namespace