通过

SubscriptionChronicleCollection.Add Method

  • 项目

Adds a SubscriptionChronicle to the SubscriptionChronicleCollection.

命名空间: Microsoft.SqlServer.Management.Nmo
程序集: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

语法

声明
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
)

参数

备注

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

示例

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)

线程安全

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.

平台

开发平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

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

其他资源

为订阅类定义历史记录
Chronicle Element for SubscriptionClass/Chronicles (ADF)