SetJoinTable Method (String, String, String, CatalogJoinType)

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.

• sourceJoinKey
  Type: System..::.String
  The source join column.

• targetJoinKey
  Type: System..::.String
  The target join column.

• joinType
  Type: Microsoft.CommerceServer.Catalog..::.CatalogJoinType
  A CatalogJoinType that contains the external SQL join type.

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

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

CatalogContext Class

CatalogContext Members

SetJoinTable Overload

Microsoft.CommerceServer.Catalog Namespace