LinkLeafCondition.LinkChain Property

아티클
12/15/2008

Gets an ordered collection of JoinClause instances describing the link between the table or view this condition references and the InputType of the Filter element.

네임스페이스: Microsoft.SqlServer.NotificationServices.Rules
어셈블리: Microsoft.SqlServer.NotificationServices.Rules (in microsoft.sqlserver.notificationservices.rules.dll)

구문

‘선언
Public ReadOnly Property LinkChain As Collection(Of JoinClause)

public Collection<JoinClause> LinkChain { get; }

public:
property Collection<JoinClause^>^ LinkChain {
    Collection<JoinClause^>^ get ();
}

/** @property */
public Collection<JoinClause> get_LinkChain ()

public function get LinkChain () : Collection<JoinClause>

속성 값

A Collection of JoinClause objects.

주의

If this chain is empty, the Filter must have the same InputType table or view as this condition.

Links in the chain must follow these rules:

The first JoinClause in the chain must have a SourceColumn value that belongs to the InputType table or view of this condition.
Subsequent JoinClause objects must have SourceColumn columns in the same table or view as the TargetColumn of the previous element.
The final link in the chain must have a TargetColumn in the same table or view as the InputType of the Filter.

예

The following example shows the link chain defined for a subscription. The link chain links the event view to the inventory table, which is linked to the location table:

// Subscribe to products in Subassembly location. This
// requires select permissions on all tables in the sample.

//Specify server and database.
Server server = new Server("MyServer");
Database db = server.Databases[nsApplication.DatabaseName];

// Specify tables and views used by the condition.
Table locationTable = db.Tables["Location", "Production"];
Table inventoryTable = db.Tables["ProductInventory", "Production"];
View eventView = db.Views["InventoryTrackerEvents",
    "NS_InventoryTrackerApplication"];

// Filter defining "Subassembly" locations.
FilterRule toolCrib = new FilterRule(
    new TableInputType(db.Tables["Location", "Production"]),
    new SimpleLeafCondition(new FieldValue("Name"),
        SimpleOperator.Equals, "Subassembly"));

// Create subscription and define basic properties.
s = new Subscription(nsApplication, subscriptionClassName);
s.SubscriberId = "Stephanie";
s.Enabled = true;
s.RuleName = "InventoryTrackerRule";
s.SetFieldValue("DeviceName", "myDevice");
s.SetFieldValue("SubscriberLocale", "en-us");

// Define a condition using the filter.
s.Condition = new LinkLeafCondition(
    LinkLeafOperator.Any,
    toolCrib,
    new JoinClause(eventView.Columns["ProductId"],
        inventoryTable.Columns["ProductId"]),
    new JoinClause(inventoryTable.Columns["LocationId"],
        locationTable.Columns["LocationId"]));

// Add subscription.
s.Add();

스레드 보안

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

플랫폼

개발 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

대상 플랫폼

지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

참고 항목

참조

LinkLeafCondition Class
LinkLeafCondition Members
Microsoft.SqlServer.NotificationServices.Rules Namespace

다음을 통해 공유