NumberedStoredProcedureCollection-Klasse

The NumberedStoredProcedureCollection class represents a collection of NumberedStoredProcedure objects that represent all the numbered stored procedures defined on a table.

Vererbungshierarchie

System. . :: . .Object
  Microsoft.SqlServer.Management.Smo. . :: . .AbstractCollectionBase
    Microsoft.SqlServer.Management.Smo. . :: . .SmoCollectionBase
      Microsoft.SqlServer.Management.Smo. . :: . .SortedListCollectionBase
        Microsoft.SqlServer.Management.Smo. . :: . .NumberedObjectCollectionBase
          Microsoft.SqlServer.Management.Smo..::..NumberedStoredProcedureCollection

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public NotInheritable Class NumberedStoredProcedureCollection _
    Inherits NumberedObjectCollectionBase
'Usage
Dim instance As NumberedStoredProcedureCollection

public sealed class NumberedStoredProcedureCollection : NumberedObjectCollectionBase

public ref class NumberedStoredProcedureCollection sealed : public NumberedObjectCollectionBase

[<SealedAttribute>]
type NumberedStoredProcedureCollection =  
    class
        inherit NumberedObjectCollectionBase
    end

public final class NumberedStoredProcedureCollection extends NumberedObjectCollectionBase

Der NumberedStoredProcedureCollection-Typ macht folgende Elemente verfügbar.

Eigenschaften

	Name	Beschreibung
	Count	Gets the number of objects in the referenced collection. (Geerbt von SmoCollectionBase.)
	IsSynchronized	Gets the Boolean property value that specifies whether access to the collection is synchronized and therefore thread-safe. (Geerbt von SmoCollectionBase.)
	Item	Gets a NumberedStoredProcedure object in the collection by index number.
	Parent	Gets the Database object that is the parent of the NumberedStoredProcedure object.
	SyncRoot	Gets an object that can be used to synchronize access to the collection. (Geerbt von SmoCollectionBase.)

Zum Anfang

Methoden

	Name	Beschreibung
	AddExisting	Adds an object to the collection. (Geerbt von AbstractCollectionBase.)
	AddImpl	Adds the specified object to this collection (Geerbt von SortedListCollectionBase.)
	Contains	Determines whether the specified value is the number value of any of the numbered objects in the referenced collection. (Geerbt von NumberedObjectCollectionBase.)
	CopyTo	Copies the collection objects to a one-dimensional array beginning at the index value specified.
	Equals	(Geerbt von Object.)
	Finalize	(Geerbt von Object.)
	GetCollectionElementType	Gets the Collection Element Type. (Geerbt von SmoCollectionBase.)
	GetEnumerator	Returns an IEnumerator interface that allows you to iterate through the objects in the collection. (Geerbt von SmoCollectionBase.)
	GetHashCode	(Geerbt von Object.)
	GetItemById(Int32)	Extracts a member from the referenced collection using a system-defined, unique identifier. (Geerbt von SmoCollectionBase.)
	GetItemById(Int32, String)	Extracts a member from the referenced collection using a system-defined, unique identifier and name. (Geerbt von SmoCollectionBase.)
	GetObjectByIndex	Extracts a member from the referenced collection using a system-defined, unique identifier. (Geerbt von SmoCollectionBase.)
	GetProcedureByNumber	Extracts a member from the NumberedStoredProcedureCollection collection by using a system-defined, unique identifier.
	GetType	(Geerbt von Object.)
	ImplAddExisting	Adds an existing specified object to this collection (Geerbt von SortedListCollectionBase.)
	InitializeChildCollection() () () ()	Initializes the child collections of the referenced collection. (Geerbt von SmoCollectionBase.)
	InitializeChildCollection(Boolean)	Initializes the child collections of the referenced collection with the option to refresh the properties of the referenced collection. (Geerbt von SmoCollectionBase.)
	InitInnerCollection	Initializes a new collection, keeping the original collection intact. (Geerbt von NumberedObjectCollectionBase.)
	MemberwiseClone	(Geerbt von Object.)
	Refresh() () () ()	Refreshes the referenced collection. (Geerbt von SmoCollectionBase.)
	Refresh(Boolean)	Refreshes the referenced collection with the option to refresh child objects of the referenced collection. (Geerbt von SmoCollectionBase.)
	ToString	(Geerbt von Object.)
	ValidateParentObject	Validates the parent object exists. (Geerbt von SmoCollectionBase.)

Zum Anfang

Felder

	Name	Beschreibung
	initialized	This value supports the SMO infrastructure and is not intended to be used directly from your code. (Geerbt von AbstractCollectionBase.)

Zum Anfang

Explizite Schnittstellenimplementierungen

	Name	Beschreibung
	ICollection. . :: . .CopyTo	Copies the elements from an instance to an array beginning at the index indicated. (Geerbt von SmoCollectionBase.)

Zum Anfang

Hinweise

A NumberedStoredProcedureCollection object can be used to gain access to a set of numbered stored procedures. You can use the Item property to return a specific NumberedStoredProcedure object.

Thread Safety

Alle öffentlichen, statischen Elemente dieses Typs (Shared in Microsoft Visual Basic) sind für Vorgänge mit mehreren Threads sicher. Für Instanzelemente kann nicht sichergestellt werden, dass sie für Threads sicher sind.

Beispiele

Verwenden von Auflistungen

Threadsicherheit

Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.

Siehe auch

Verweis

Microsoft.SqlServer.Management.Smo-Namespace