Classe NumberedStoredProcedureCollection
The NumberedStoredProcedureCollection class represents a collection of NumberedStoredProcedure objects that represent all the numbered stored procedures defined on a table.
Hiérarchie d'héritage
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
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
Public NotInheritable Class NumberedStoredProcedureCollection _
Inherits NumberedObjectCollectionBase
'Utilisation
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
Le type NumberedStoredProcedureCollection expose les membres suivants.
Propriétés
Nom | Description | |
---|---|---|
Count | Gets the number of objects in the referenced collection. (hérité de SmoCollectionBase.) | |
IsSynchronized | Gets the Boolean property value that specifies whether access to the collection is synchronized and therefore thread-safe. (hérité de 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. (hérité de SmoCollectionBase.) |
Haut de la page
Méthodes
Nom | Description | |
---|---|---|
AddExisting | Adds an object to the collection. (hérité de AbstractCollectionBase.) | |
Contains | Determines whether the specified value is the number value of any of the numbered objects in the referenced collection. (hérité de NumberedObjectCollectionBase.) | |
CopyTo | Copies the collection objects to a one-dimensional array beginning at the index value specified. | |
Equals | (hérité de Object.) | |
GetEnumerator | Returns an IEnumerator interface that allows you to iterate through the objects in the collection. (hérité de SmoCollectionBase.) | |
GetHashCode | (hérité de Object.) | |
GetProcedureByNumber | Extracts a member from the NumberedStoredProcedureCollection collection by using a system-defined, unique identifier. | |
GetType | (hérité de Object.) | |
Refresh() | Refreshes the referenced collection. (hérité de SmoCollectionBase.) | |
Refresh(Boolean) | Refreshes the referenced collection with the option to refresh child objects of the referenced collection. (hérité de SmoCollectionBase.) | |
ToString | (hérité de Object.) |
Haut de la page
Champs
Nom | Description | |
---|---|---|
initialized | This value supports the SMO infrastructure and is not intended to be used directly from your code. (hérité de AbstractCollectionBase.) |
Haut de la page
Implémentations d'interfaces explicites
Nom | Description | |
---|---|---|
ICollection.CopyTo | Copies the elements from an instance to an array beginning at the index indicated. (hérité de SmoCollectionBase.) |
Haut de la page
Notes
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
Tout membre statique public (Partagé dans Microsoft Visual Basic) de ce type est sûr dans le cadre des opérations à plusieurs threads. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.
Exemples
Sécurité des threads
Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.