DbParameterCollection Class
.NET Framework 4
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
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 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
