DbParameterCollection Class
.NET Framework 4.5
The base class for a collection of parameters relevant to a DbCommand.
System.Object
System.MarshalByRefObject
System.Data.Common.DbParameterCollection
System.Data.EntityClient.EntityParameterCollection
System.Data.Odbc.OdbcParameterCollection
System.Data.OleDb.OleDbParameterCollection
System.Data.OracleClient.OracleParameterCollection
System.Data.SqlClient.SqlParameterCollection
System.MarshalByRefObject
System.Data.Common.DbParameterCollection
System.Data.EntityClient.EntityParameterCollection
System.Data.Odbc.OdbcParameterCollection
System.Data.OleDb.OleDbParameterCollection
System.Data.OracleClient.OracleParameterCollection
System.Data.SqlClient.SqlParameterCollection
Namespace: System.Data.Common
Assembly: System.Data (in System.Data.dll)
The DbParameterCollection type exposes the following members.
| Name | Description | |
|---|---|---|
 | DbParameterCollection | Initializes a new instance of the DbParameterCollection class. |
| Name | Description | |
|---|---|---|
| Count | Specifies the number of items in the collection. |
| IsFixedSize | Specifies whether the collection is a fixed size. |
| IsReadOnly | Specifies whether the collection is read-only. |
| IsSynchronized | Specifies whether the collection is synchronized. |
| Item[Int32] | Gets and sets the DbParameter at the specified index. |
| Item[String] | Gets and sets the DbParameter with the specified name. |
| SyncRoot | Specifies the Object to be used to synchronize access to the collection. |
| Name | Description | |
|---|---|---|
| Add | Adds the specified DbParameter object to the DbParameterCollection. |
| AddRange | Adds an array of items with the specified values to the DbParameterCollection. |
| Clear | Removes all DbParameter values from the DbParameterCollection. |
| Contains(Object) | Indicates whether a DbParameter with the specified Value is contained in the collection. |
| Contains(String) | Indicates whether a DbParameter with the specified name exists in the collection. |
| CopyTo | Copies an array of items to the collection starting at the specified index. |
| CreateObjRef | Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from MarshalByRefObject.) |
| Equals(Object) | Determines whether the specified object is equal to the current object. (Inherited from Object.) |
| Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| GetEnumerator | Exposes the GetEnumerator method, which supports a simple iteration over a collection by a .NET Framework data provider. |
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetLifetimeService | Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.) |
| GetParameter(Int32) | Returns the DbParameter object at the specified index in the collection. |
| GetParameter(String) | Returns DbParameter the object with the specified name. |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| IndexOf(Object) | Returns the index of the specified DbParameter object. |
| IndexOf(String) | Returns the index of the DbParameter object with the specified name. |
| InitializeLifetimeService | Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.) |
| Insert | Inserts the specified index of the DbParameter object with the specified name into the collection at the specified index. |
| MemberwiseClone() | Creates a shallow copy of the current Object. (Inherited from Object.) |
| MemberwiseClone(Boolean) | Creates a shallow copy of the current MarshalByRefObject object. (Inherited from MarshalByRefObject.) |
| Remove | Removes the specified DbParameter object from the collection. |
| RemoveAt(Int32) | Removes the DbParameter object at the specified from the collection. |
| RemoveAt(String) | Removes the DbParameter object with the specified name from the collection. |
| SetParameter(Int32, DbParameter) | Sets the DbParameter object at the specified index to a new value. |
| SetParameter(String, DbParameter) | Sets the DbParameter object with the specified name to a new value. |
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
| Name | Description | |
|---|---|---|
| AsParallel | Enables parallelization of a query. (Defined by ParallelEnumerable.) |
| AsQueryable | Converts an IEnumerable to an IQueryable. (Defined by Queryable.) |
| Cast<TResult> | Casts the elements of an IEnumerable to the specified type. (Defined by Enumerable.) |
| OfType<TResult> | Filters the elements of an IEnumerable based on a specified type. (Defined by Enumerable.) |
| Name | Description | |
|---|---|---|
 | IDataParameterCollection.Item | Gets or sets the parameter at the specified index. |
| IList.Item | Gets or sets the element at the specified index. |
Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
