SubscriptionEventRule Constructor ()

Artikkeli
12/03/2008

Initializes a new instance of the SubscriptionEventRule class.

Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
Public Sub New

public SubscriptionEventRule ()

public:
SubscriptionEventRule ()

public SubscriptionEventRule ()

public function SubscriptionEventRule ()

Remarks

Updated text:5 December 2005

Updated sample code:5 December 2005

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

Example

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

// Create an event rule and set properties.
SubscriptionEventRule flightEventRule = new SubscriptionEventRule();
flightEventRule.Name = "FlightSubscriptionsEventRule";
flightEventRule.Parent = flightSubscriptions;
flightEventRule.Action = "INSERT INTO FlightNotifications " + 
    "(SubscriberId, DeviceName, SubscriberLocale, " + 
    "LeavingFrom, GoingTo, Price) " + 
    "SELECT S.SubscriberId, S.DeviceName, S.SubscriberLocale, " + 
    "E.LeavingFrom, E.GoingTo, E.Price " + 
    "FROM FlightEvents E, FlightSubscriptions S " + 
    "WHERE     E.LeavingFrom     = S.LeavingFrom " + 
    "AND    E.GoingTo    = S.GoingTo " + 
    "AND    E.Price    < S.Price";
flightEventRule.ActionTimeout = new TimeSpan(0, 30, 0);
flightEventRule.EventClassName = "FlightEvents";
flightSubscriptions.SubscriptionEventRules.Add(flightEventRule);

' Create an event rule and set properties.
Dim flightEventRule As SubscriptionEventRule = _
    New SubscriptionEventRule()
flightEventRule.Name = "FlightSubscriptionsEventRule"
flightEventRule.Parent = flightSubscriptions
flightEventRule.Action = "INSERT INTO FlightNotifications " + _
    "(SubscriberId, DeviceName, SubscriberLocale, " + _
    "LeavingFrom, GoingTo, Price) " + _
    "SELECT S.SubscriberId, S.DeviceName, S.SubscriberLocale, " + _
    "E.LeavingFrom, E.GoingTo, E.Price " + _
    "FROM FlightEvents E, FlightSubscriptions S " + _
    "WHERE     E.LeavingFrom     = S.LeavingFrom " + _
    "AND    E.GoingTo    = S.GoingTo " + _
    "AND    E.Price    < S.Price"
flightEventRule.ActionTimeout = New TimeSpan(0, 30, 0)
flightEventRule.EventClassName = "FlightEvents"
flightSubscriptions.SubscriptionEventRules.Add(flightEventRule)

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms