DbParameterCollection Class

Definition

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

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

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

ICollection.IsSynchronized

Gets a value indicating whether access to the ICollection is synchronized (thread safe).

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.IsFixedSize

Gets a value indicating whether the IList has a fixed size.

IList.IsReadOnly

Gets a value indicating whether the IList is read-only.

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.

Applies to

Product Versions
.NET Core 1.0, Core 1.1, Core 2.0, Core 2.1, Core 2.2, Core 3.0, Core 3.1, 5, 6, 7, 8, 9
.NET Framework 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard 2.0, 2.1
UWP 10.0

See also