SubscriptionField Constructor (SubscriptionClass, String)

Initializes a new instance of the SubscriptionField class with a SubscriptionClass object and a name.

Espacio de nombres: Microsoft.SqlServer.Management.Nmo
Ensamblado: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Sintaxis

'Declaración
Public Sub New ( _
    subscriptionClass As SubscriptionClass, _
    name As String _
)

public SubscriptionField (
    SubscriptionClass subscriptionClass,
    string name
)

public:
SubscriptionField (
    SubscriptionClass^ subscriptionClass, 
    String^ name
)

public SubscriptionField (
    SubscriptionClass subscriptionClass, 
    String name
)

public function SubscriptionField (
    subscriptionClass : SubscriptionClass, 
    name : String
)

Parámetros

subscriptionClass
The parent SubscriptionClass object for the subscription field.

name
A String, between 1 and 128 characters in length, that specifies the name of the subscription field.

You cannot change the name. To rename a subscription field, remove the field and then add a new subscription field that has the new name.

Notas

You must set the Type property. Setting the TypeModifier property is optional.

Field names must start with a letter or underscore character and can contain letters, numbers, and the characters _, #, @ and $. They must also conform to Microsoft SQL Server identifier conventions. For more information about SQL Server identifiers, see Identificadores.

Importante:
You cannot name a subscription field Created, Enabled, SubscriberId, SubscriptionId, or Updated. Microsoft SQL Server 2005 Notification Services already uses these field names internally.

If you update the name, updating the application re-creates the subscription class to which it corresponds. Notification Services renames the existing subscription tables by appending "Old" to the table name and then creates new tables. Existing subscription table indexes are left unchanged.

If you want to transfer data between the old and new subscription tables, it must be done manually. For more information, see Actualizar una aplicación.

Ejemplo

The following examples show how to define a subscription field and add it to the subscription schema:

// Define a SubscriberLocale field that cannot be NULL
// Add the field to the end of the field collection
SubscriptionField subLocale = 
    new SubscriptionField(flightSubscriptions, "SubscriberLocale");
subLocale.Type = "nvarchar(10)";
subLocale.TypeModifier = "not null";
flightSubscriptions.SubscriptionFields.Add(subLocale);

' Define a SubscriberLocale field that cannot be NULL
' Add the field to the end of the field collection
Dim subLocale As SubscriptionField = _
    New SubscriptionField(flightSubscriptions, _
    "SubscriberLocale")
subLocale.Type = "nvarchar(10)"
subLocale.TypeModifier = "not null"
flightSubscriptions.SubscriptionFields.Add(subLocale)