Clase StoredProcedureParameterCollection
The StoredProcedureParameterCollection class represents a collection of StoredProcedureParameter objects that represent all the stored procedure parameters defined on a table.
Jerarquía de herencia
System.Object
Microsoft.SqlServer.Management.Smo.AbstractCollectionBase
Microsoft.SqlServer.Management.Smo.SmoCollectionBase
Microsoft.SqlServer.Management.Smo.ArrayListCollectionBase
Microsoft.SqlServer.Management.Smo.ParameterCollectionBase
Microsoft.SqlServer.Management.Smo.StoredProcedureParameterCollection
Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Sintaxis
'Declaración
Public NotInheritable Class StoredProcedureParameterCollection _
Inherits ParameterCollectionBase
'Uso
Dim instance As StoredProcedureParameterCollection
public sealed class StoredProcedureParameterCollection : ParameterCollectionBase
public ref class StoredProcedureParameterCollection sealed : public ParameterCollectionBase
[<SealedAttribute>]
type StoredProcedureParameterCollection =
class
inherit ParameterCollectionBase
end
public final class StoredProcedureParameterCollection extends ParameterCollectionBase
El tipo StoredProcedureParameterCollection expone los siguientes miembros.
Propiedades
| Nombre | Descripción | |
|---|---|---|
.gif "Propiedad pública") |
Count | Gets the number of objects in the referenced collection. (Se hereda de SmoCollectionBase.) |
|
IsSynchronized | Gets the Boolean property value that specifies whether access to the collection is synchronized and therefore thread-safe. (Se hereda de SmoCollectionBase.) |
|
Item[Int32] | Gets a StoredProcedureParameter object in the collection by index number. |
|
Item[String] | Gets a StoredProcedureParameter object in the collection by name. |
|
Parent | Gets the StoredProcedure object that is the parent of the StoredProcedureParameter object. |
|
SyncRoot | Gets an object that can be used to synchronize access to the collection. (Se hereda de SmoCollectionBase.) |
Arriba
Métodos
| Nombre | Descripción | |
|---|---|---|
.gif "Método público") |
Add(StoredProcedureParameter) | Adds a StoredProcedureParameter object to the StoredProcedureParameterCollection object. |
|
Add(StoredProcedureParameter, Int32) | Adds a StoredProcedureParameter object to the StoredProcedureParameterCollection object. |
|
Add(StoredProcedureParameter, String) | Adds a StoredProcedureParameter object to the StoredProcedureParameterCollection object. |
.gif "Método protegido") |
AddExisting | Adds an object to the collection. (Se hereda de AbstractCollectionBase.) |
|
Contains | Validates whether the parameter collection contains a member with a name equal to the specified string. (Se hereda de ParameterCollectionBase.) |
|
CopyTo | Copies the collection objects to a one-dimensional array starting at the index value specified. |
|
Equals | (Se hereda de Object.) |
|
GetEnumerator | Returns an IEnumerator interface that allows you to iterate through the objects in the collection. (Se hereda de SmoCollectionBase.) |
|
GetHashCode | (Se hereda de Object.) |
|
GetType | (Se hereda de Object.) |
|
ItemById | Extracts a member from the StoredProcedureParameterCollection object using a system-defined, unique identifier. |
|
Refresh() | Refreshes the referenced collection. (Se hereda de SmoCollectionBase.) |
|
Refresh(Boolean) | Refreshes the referenced collection with the option to refresh child objects of the referenced collection. (Se hereda de SmoCollectionBase.) |
|
Remove(String) | Removes a member from the collection with the specified name. (Se hereda de ParameterCollectionBase.) |
|
Remove(StoredProcedureParameter) | Removes a StoredProcedureParameter object from the StoredProcedureParameterCollection object. |
|
ToString | (Se hereda de Object.) |
Arriba
Campos
| Nombre | Descripción | |
|---|---|---|
.gif "Campo protegido") |
initialized | This value supports the SMO infrastructure and is not intended to be used directly from your code. (Se hereda de AbstractCollectionBase.) |
Arriba
Implementaciones de interfaces explícitas
| Nombre | Descripción | |
|---|---|---|
.gif "Implementación de interfaces explícitas") .gif "Método privado") |
ICollection.CopyTo | Copies the elements from an instance to an array beginning at the index indicated. (Se hereda de SmoCollectionBase.) |
Arriba
Comentarios
A StoredProcedureParameterCollection object can be used to gain access to a set of stored procedure parameters. You can use the Item property to return a specific StoredProcedureParameter object.
Thread Safety
Todos los miembros estáticos (compartidos en Microsoft Visual Basic) públicos de este tipo son seguros para operaciones multiproceso. No se garantiza que los miembros de instancia sean seguros para subprocesos.
Ejemplos
Seguridad para subprocesos
Cualquier miembro público static (Shared en Visual Basic) de este tipo es seguro para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.