DbParameterCollection Class

Definition

Namespace:

System.Data.Common

Assembly:

System.Data.Common.dll

Source:

DbParameterCollection.cs

The base class for a collection of parameters relevant to a DbCommand.

public ref class DbParameterCollection abstract : MarshalByRefObject, System::Collections::IList, System::Data::IDataParameterCollection

public abstract class DbParameterCollection : MarshalByRefObject, System.Collections.IList, System.Data.IDataParameterCollection

type DbParameterCollection = class
    inherit MarshalByRefObject
    interface ICollection
    interface IEnumerable
    interface IList
    interface IDataParameterCollection

Public MustInherit Class DbParameterCollection
Inherits MarshalByRefObject
Implements IDataParameterCollection, IList

Inheritance

Object

MarshalByRefObject

DbParameterCollection

Derived

System.Data.EntityClient.EntityParameterCollection

System.Data.Odbc.OdbcParameterCollection

System.Data.OleDb.OleDbParameterCollection

System.Data.SqlClient.SqlParameterCollection

Implements

ICollection IEnumerable IList IDataParameterCollection

Constructors

DbParameterCollection()

Initializes a new instance of the DbParameterCollection class.

Properties

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 or sets the DbParameter at the specified index.
Item[String]	Gets or sets the DbParameter with the specified name.
SyncRoot	Specifies the Object to be used to synchronize access to the collection.

Methods

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)
GetEnumerator()	Exposes the GetEnumerator() method, which supports a simple iteration over a collection by a .NET data provider.
GetHashCode()	Serves as the default hash function. (Inherited from Object)
GetLifetimeService()	Obsolete. 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()	Obsolete. 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()	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(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)

Explicit Interface Implementations

IDataParameterCollection.Item[String]	Gets or sets the parameter at the specified index.
IList.Add(Object)	For a description of this member, see Add(Object).
IList.Contains(Object)	For a description of this member, see Contains(Object).
IList.IndexOf(Object)	For a description of this member, see IndexOf(Object).
IList.Insert(Int32, Object)	For a description of this member, see Insert(Int32, Object).
IList.Item[Int32]	Gets or sets the element at the specified index.
IList.Remove(Object)	For a description of this member, see Remove(Object).

Extension Methods

Cast<TResult>(IEnumerable)	Casts the elements of an IEnumerable to the specified type.
OfType<TResult>(IEnumerable)	Filters the elements of an IEnumerable based on a specified type.
AsParallel(IEnumerable)	Enables parallelization of a query.
AsQueryable(IEnumerable)	Converts an IEnumerable to an IQueryable.

See also

• DbProviderFactories (ADO.NET)
• ADO.NET Overview