SubscriptionClass.SubscriptionChronicles Property

Gets the SubscriptionChronicleCollection for the SubscriptionClass.

Пространство имен: Microsoft.SqlServer.Management.Nmo
Сборка: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Синтаксис

'Декларация
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

Значение свойства

The SubscriptionChronicleCollection for the SubscriptionClass.

Замечания

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

Define individual subscription chronicles using the SubscriptionChronicle class.

Пример

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)

Синхронизация потоков

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.

Платформы

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

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

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

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

См. также

Справочник

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

Другие ресурсы

Определение хроники для класса подписки
Chronicles Element for SubscriptionClass (ADF)