SubscriptionChronicleCollection.Add Method

Adds a SubscriptionChronicle to the SubscriptionChronicleCollection.

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

Syntax

'Declaration
Public Sub Add ( _
    subscriptionChronicle As SubscriptionChronicle _
)

public void Add (
    SubscriptionChronicle subscriptionChronicle
)

public:
void Add (
    SubscriptionChronicle^ subscriptionChronicle
)

public void Add (
    SubscriptionChronicle subscriptionChronicle
)

public function Add (
    subscriptionChronicle : SubscriptionChronicle
)

Parameter

subscriptionChronicle
The SubscriptionChronicle to add to the collection.

Hinweise

If you add a SubscriptionChronicle after deploying the application, you must Update the instance to apply the changes.

Beispiel

The following examples show how to create a subscription chronicle and add it to the collection of subscription chronicles for a subscription class:

// Define a chronicle for the subscription class
SubscriptionChronicle sc1 = new SubscriptionChronicle(
    flightSubscriptions, "FlightSubChronicle");
sc1.SqlStatements.Add(
    "CREATE TABLE MyAppSchema.FlightSubChronicle " + 
    " (SubscriptionId bigint, LeavingFrom nvarchar(6), " + 
    "  GoingTo nvarchar(6), Price float);");
sc1.SqlStatements.Add(
    "CREATE INDEX FlightSubChronicleIndex  " +
    " ON MyAppSchema.FlightSubChronicle " +
    " ( LeavingFrom, GoingTo );");
flightSubscriptions.SubscriptionChronicles.Add(sc1);

' Define a chronicle for the subscription class
Dim sc1 As SubscriptionChronicle = New SubscriptionChronicle( _
    flightSubscriptions, "FlightSubChronicle")
sc1.SqlStatements.Add( _
    "CREATE TABLE MyAppSchema.FlightSubChronicle " + _
    "(SubscriptionId bigint, LeavingFrom nvarchar(6), " + _
    "GoingTo nvarchar(6), Price float);")
sc1.SqlStatements.Add( _
    "CREATE INDEX FlightSubChronicleIndex  " + _
    "ON MyAppSchema.FlightSubChronicle " + _
    "( LeavingFrom, GoingTo );")
flightSubscriptions.SubscriptionChronicles.Add(sc1)

Threadsicherheit

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.