SubscriptionConditionEventRule Constructor ()

Initializes a new instance of the SubscriptionConditionEventRule class.

命名空間: Microsoft.SqlServer.Management.Nmo
組件: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

語法

'宣告
Public Sub New

public SubscriptionConditionEventRule ()

public:
SubscriptionConditionEventRule ()

public SubscriptionConditionEventRule ()

public function SubscriptionConditionEventRule ()

備註

更新的文字：2005 年 12 月 5 日

更新的範例程式碼：2005 年 12 月 5 日

When using the default constructor, first set the Name, then the Parent, and then other properties. This constructor does not set any property values.

範例

The following examples show how to use this default constructor to create condition-based, event-driven subscription rule and add the rule to a subscription class:

' Create a condition-based event rule and set properties.
Dim flightConditionEventRule As SubscriptionConditionEventRule = _
    New SubscriptionConditionEventRule()
flightConditionEventRule.Name = "FlightConditionEventRule"
flightConditionEventRule.Parent = flightSubscriptions
flightConditionEventRule.EventClassName = "FlightEvents"
flightConditionEventRule.ActionTimeout = New TimeSpan(0, 30, 0)
flightConditionEventRule.SqlLoginName = "MyLowPrivLogin"
flightConditionEventRule.SqlUserName = "MyLowPrivUser"
flightConditionEventRule.InputTypeName = "FlightEvents"
flightConditionEventRule.InputTypeSchema = "dbo"
flightConditionEventRule.SqlExpression = _
    "INSERT INTO dbo.FlightNotifications (SubscriberId, " + _
    "DeviceName, SubscriberLocale, LeavingFrom, GoingTo, Price) " + _
    "SELECT [Subscription.SubscriberId], [Subscription.DeviceName], " + _
    "[Subscription.SubscriberLocale], " + _
    "[Input.LeavingFrom], [Input.GoingTo], [Input.Price] " + _
    "FROM dbo.FlightConditionEventRule;"
flightSubscriptions.SubscriptionConditionEventRules.Add(flightConditionEventRule)

// Create a condition-based event rule and set properties.
SubscriptionConditionEventRule flightConditionEventRule = 
    new SubscriptionConditionEventRule();
flightConditionEventRule.Name = "FlightConditionEventRule";
flightConditionEventRule.Parent = flightSubscriptions;
flightConditionEventRule.EventClassName = "FlightEvents";
flightConditionEventRule.ActionTimeout = new TimeSpan(0, 30, 0);
flightConditionEventRule.SqlLoginName = "MyLowPrivLogin";
flightConditionEventRule.SqlUserName = "MyLowPrivUser";
flightConditionEventRule.InputTypeName = "FlightEvents";
flightConditionEventRule.InputTypeSchema = "dbo";
flightConditionEventRule.SqlExpression = 
    "INSERT INTO dbo.FlightNotifications (SubscriberId, " +
    "DeviceName, SubscriberLocale, LeavingFrom, GoingTo, Price) " +
    "SELECT [Subscription.SubscriberId], [Subscription.DeviceName], " +
    "[Subscription.SubscriberLocale], " +
    "[Input.LeavingFrom], [Input.GoingTo], [Input.Price] " +
    "FROM dbo.FlightConditionEventRule;";
flightSubscriptions.SubscriptionConditionEventRules.Add(
    flightConditionEventRule);

平台

開發平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

目標平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

請參閱

參考

SubscriptionConditionEventRule Class
SubscriptionConditionEventRule Members
Microsoft.SqlServer.Management.Nmo Namespace