EventChronicleCollection.Add Method
Adds an EventChronicle to the EventChronicleCollection.
Spazio dei nomi: Microsoft.SqlServer.Management.Nmo
Assembly : Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Sintassi
'Dichiarazione
Public Sub Add ( _
eventChronicle As EventChronicle _
)
public void Add (
EventChronicle eventChronicle
)
public:
void Add (
EventChronicle^ eventChronicle
)
public void Add (
EventChronicle eventChronicle
)
public function Add (
eventChronicle : EventChronicle
)
Parametri
- eventChronicle
The EventChronicle to add to the collection.
Osservazioni
The name of each event chronicle must be unique within the application.
If you add event chronicles to an application after deploying the application, you must Update the instance to apply the changes.
Esempio
The following examples show how to define an event chronicle and add it to the collection of chronicles for an event class:
// Define a chronicle for the class
EventChronicle ec1 =
new EventChronicle(flightEvents, "FlightEventChonicle");
ec1.SqlStatements.Add(
"CREATE TABLE MyAppSchema.FlightEventChronicle " +
" (LeavingFrom nvarchar(6), GoingTo nvarchar(6), " +
" Price float);");
ec1.SqlStatements.Add(
"CREATE INDEX FlightEventChronicleIndex " +
"ON MyAppSchema.FlightEventChronicle " +
"( LeavingFrom, GoingTo );");
flightEvents.EventChronicles.Add(ec1);
' Define a chronicle for the class.
Dim ec1 As EventChronicle = _
New EventChronicle(flightEvents, "FlightEventChonicle")
ec1.SqlStatements.Add( _
"CREATE TABLE MyAppSchema.FlightEventChronicle " + _
" (LeavingFrom nvarchar(6), GoingTo nvarchar(6), " + _
" Price float);")
ec1.SqlStatements.Add( _
"CREATE INDEX FlightEventChronicleIndex " + _
"ON MyAppSchema.FlightEventChronicle " + _
"( LeavingFrom, GoingTo );")
flightEvents.EventChronicles.Add(ec1)
Thread Safety
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.
Piattaforme
Piattaforme di sviluppo
Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.
Piattaforme di destinazione
Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.
Vedere anche
Riferimento
EventChronicleCollection Class
EventChronicleCollection Members
Microsoft.SqlServer.Management.Nmo Namespace