SubscriptionConditionEventRule Constructor ()

Статья
12/15/2008

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 ()

Замечания

Изменения текста5 декабря 2005 г.

Изменения образцов кода5 декабря 2005 г.

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

Платформы

Платформы разработки

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

Целевые платформы

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

См. также

Справочник

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

Поделиться через