共用方式為

LinkLeafCondition.LinkChain Property

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

  • Last updated on