SubscriptionConditionEventRule Constructor ()
Initializes a new instance of the SubscriptionConditionEventRule class.
Espacio de nombres: Microsoft.SqlServer.Management.Nmo
Ensamblado: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Sintaxis
'Declaración
Public Sub New
public SubscriptionConditionEventRule ()
public:
SubscriptionConditionEventRule ()
public SubscriptionConditionEventRule ()
public function SubscriptionConditionEventRule ()
Notas
Texto actualizado:5 de diciembre de 2005
Código de ejemplo actualizado:5 de diciembre de 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.
Ejemplo
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);
Plataformas
Plataformas de desarrollo
Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.
Plataformas de destino
Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.
Vea también
Referencia
SubscriptionConditionEventRule Class
SubscriptionConditionEventRule Members
Microsoft.SqlServer.Management.Nmo Namespace