SubscriptionClass.SubscriptionChronicles Property

Article
12/15/2008

Gets the SubscriptionChronicleCollection for the SubscriptionClass.

Espace de noms: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntaxe

'Déclaration
Public ReadOnly Property SubscriptionChronicles As SubscriptionChronicleCollection

public SubscriptionChronicleCollection SubscriptionChronicles { get; }

public:
property SubscriptionChronicleCollection^ SubscriptionChronicles {
    SubscriptionChronicleCollection^ get ();
}

/** @property */
public SubscriptionChronicleCollection get_SubscriptionChronicles ()

public function get SubscriptionChronicles () : SubscriptionChronicleCollection

Valeur de propriété

The SubscriptionChronicleCollection for the SubscriptionClass.

Notes

Subscription chronicles, which are optional, store supplemental subscription data for use by your application.

Define individual subscription chronicles using the SubscriptionChronicle class.

Exemple

The following examples show how to add a subscription chronicle to 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)

Sécurité des threads

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.

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

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

Autres ressources

Définition de chroniques pour une classe d'abonnement
Chronicles Element for SubscriptionClass (ADF)

Partager via