SubscriptionChronicle Constructor ()

Artikkeli
12/03/2008

Initializes a new instance of the SubscriptionChronicle class.

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

Syntax

'Declaration
Public Sub New

public SubscriptionChronicle ()

public:
SubscriptionChronicle ()

public SubscriptionChronicle ()

public function SubscriptionChronicle ()

Remarks

Updated text:5 December 2005

Updated sample code:5 December 2005

If you use the default constructor, you must immediately set the Name property and then set the Parent property. You can then set other properties.

Example

The following examples show how to use this default constructor to create a subscription chronicle and add it to a subscription class:

// Create a subscription chronicle and set properties.
SubscriptionChronicle sc1 = new SubscriptionChronicle();
sc1.Name = "FlightSubChronicle";
sc1.Parent = flightSubscriptions;
sc1.SqlStatements.Add("CREATE TABLE dbo.FlightSubChronicle " + 
    " (SubscriptionId bigint, LeavingFrom nvarchar(6), " + 
    "  GoingTo nvarchar(6), Price float);");
sc1.SqlStatements.Add("CREATE INDEX FlightSubChronicleIndex  " +
    " ON dbo.FlightSubChronicle " +
    " ( LeavingFrom, GoingTo );");
flightSubscriptions.SubscriptionChronicles.Add(sc1);

' Create a subscription chronicle and set properties.
Dim sc1 As SubscriptionChronicle = New SubscriptionChronicle()
sc1.Name = "FlightSubChronicle"
sc1.Parent = flightSubscriptions
sc1.SqlStatements.Add("CREATE TABLE dbo.FlightSubChronicle " + _
    " (SubscriptionId bigint, LeavingFrom nvarchar(6), " + _
    "  GoingTo nvarchar(6), Price float);")
sc1.SqlStatements.Add("CREATE INDEX FlightSubChronicleIndex  " + _
    " ON dbo.FlightSubChronicle " + _
    " ( LeavingFrom, GoingTo );")
flightSubscriptions.SubscriptionChronicles.Add(sc1)

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms