SubscriptionConditionEventRule.Parent Property

Artikkeli
12/03/2008

Gets or sets the parent SubscriptionClass object for the SubscriptionConditionEventRule.

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

Syntax

'Declaration
Public Property Parent As SubscriptionClass

public SubscriptionClass Parent { get; set; }

public:
property SubscriptionClass^ Parent {
    SubscriptionClass^ get ();
    void set (SubscriptionClass^ value);
}

/** @property */
public SubscriptionClass get_Parent ()

/** @property */
public void set_Parent (SubscriptionClass value)

public function get Parent () : SubscriptionClass

public function set Parent (value : SubscriptionClass)

Property Value

The parent SubscriptionClass object.

Remarks

Updated text:5 December 2005

Updated sample code:5 December 2005

Each SubscriptionConditionEventRule has a parent SubscriptionClass. You typically supply the parent object when you create the SubscriptionConditionEventRule using the SubscriptionConditionEventRule(SubscriptionClass,String) constructor.

If you set the parent in the constructor, do not set the parent using this property. Setting the parent twice throws an exception.

Example

The following examples show how to set the Parent property when using the default constructor:

' 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);

Thread Safety

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.

Platforms

Development Platforms

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

Target Platforms