DbParameterCollection Class
 Note |
|---|
The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience. |
The base class for a collection of parameters relevant to a DbCommand.
Assembly: System.Data (in System.Data.dll)
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
| 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(Object) | Adds the specified DbParameter object to the DbParameterCollection. |
| AddRange(Array) | 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(Array, Int32) | Copies an array of items to the collection starting at the specified index. |
| CreateObjRef(Type) | 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 the default hash function. (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() | |
| 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(Int32, Object) | Inserts the specified index of the DbParameter object with the specified name into the collection at the specified index. |
| MemberwiseClone() | |
| MemberwiseClone(Boolean) | Creates a shallow copy of the current MarshalByRefObject object.(Inherited from MarshalByRefObject.) |
| Remove(Object) | 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 | |
|---|---|---|
  | IList.Item[Int32] | Gets or sets the element at the specified index. |
| IDataParameterCollection.Item[String] | Gets or sets the parameter at the specified index. |
| Name | Description | |
|---|---|---|
| AsParallel() | Overloaded. Enables parallelization of a query.(Defined by ParallelEnumerable.) |
| AsQueryable() | Overloaded. 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.) |
Available since 10
.NET Framework
Available since 2.0
Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.