DbParameterCollection DbParameterCollection DbParameterCollection DbParameterCollection Class

Definition

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 IDataParameterCollection
    interface IList
    interface ICollection
    interface IEnumerable
Public MustInherit Class DbParameterCollection
Inherits MarshalByRefObject
Implements IDataParameterCollection, IList
Inheritance
DbParameterCollectionDbParameterCollectionDbParameterCollectionDbParameterCollection
Derived
Implements

Constructors

DbParameterCollection() DbParameterCollection() DbParameterCollection() DbParameterCollection()

Initializes a new instance of the DbParameterCollection class.

Properties

Count Count Count Count

Specifies the number of items in the collection.

IsFixedSize IsFixedSize IsFixedSize IsFixedSize

Specifies whether the collection is a fixed size.

IsReadOnly IsReadOnly IsReadOnly IsReadOnly

Specifies whether the collection is read-only.

IsSynchronized IsSynchronized IsSynchronized IsSynchronized

Specifies whether the collection is synchronized.

Item[Int32] Item[Int32] Item[Int32] Item[Int32]

Gets or sets the DbParameter at the specified index.

Item[String] Item[String] Item[String] Item[String]

Gets or sets the DbParameter with the specified name.

SyncRoot SyncRoot SyncRoot SyncRoot

Specifies the Object to be used to synchronize access to the collection.

Methods

Add(Object) Add(Object) Add(Object) Add(Object)

Adds the specified DbParameter object to the DbParameterCollection.

AddRange(Array) AddRange(Array) AddRange(Array) AddRange(Array)

Adds an array of items with the specified values to the DbParameterCollection.

Clear() Clear() Clear() Clear()

Removes all DbParameter values from the DbParameterCollection.

Contains(Object) Contains(Object) Contains(Object) Contains(Object)

Indicates whether a DbParameter with the specified Value is contained in the collection.

Contains(String) Contains(String) Contains(String) Contains(String)

Indicates whether a DbParameter with the specified name exists in the collection.

CopyTo(Array, Int32) CopyTo(Array, Int32) CopyTo(Array, Int32) CopyTo(Array, Int32)

Copies an array of items to the collection starting at the specified index.

CreateObjRef(Type) CreateObjRef(Type) CreateObjRef(Type) 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) Equals(Object) Equals(Object) Equals(Object)

Determines whether the specified object is equal to the current object.

(Inherited from Object)
GetEnumerator() GetEnumerator() GetEnumerator() GetEnumerator()

Exposes the GetEnumerator() method, which supports a simple iteration over a collection by a .NET Framework data provider.

GetHashCode() GetHashCode() GetHashCode() GetHashCode()

Serves as the default hash function.

(Inherited from Object)
GetLifetimeService() GetLifetimeService() GetLifetimeService() GetLifetimeService()

Retrieves the current lifetime service object that controls the lifetime policy for this instance.

(Inherited from MarshalByRefObject)
GetParameter(Int32) GetParameter(Int32) GetParameter(Int32) GetParameter(Int32)

Returns the DbParameter object at the specified index in the collection.

GetParameter(String) GetParameter(String) GetParameter(String) GetParameter(String)

Returns DbParameter the object with the specified name.

GetType() GetType() GetType() GetType()

Gets the Type of the current instance.

(Inherited from Object)
IndexOf(Object) IndexOf(Object) IndexOf(Object) IndexOf(Object)

Returns the index of the specified DbParameter object.

IndexOf(String) IndexOf(String) IndexOf(String) IndexOf(String)

Returns the index of the DbParameter object with the specified name.

InitializeLifetimeService() InitializeLifetimeService() InitializeLifetimeService() InitializeLifetimeService()

Obtains a lifetime service object to control the lifetime policy for this instance.

(Inherited from MarshalByRefObject)
Insert(Int32, Object) Insert(Int32, Object) Insert(Int32, Object) Insert(Int32, Object)

Inserts the specified index of the DbParameter object with the specified name into the collection at the specified index.

MemberwiseClone() MemberwiseClone() MemberwiseClone() MemberwiseClone()

Creates a shallow copy of the current Object.

(Inherited from Object)
MemberwiseClone(Boolean) MemberwiseClone(Boolean) MemberwiseClone(Boolean) MemberwiseClone(Boolean)

Creates a shallow copy of the current MarshalByRefObject object.

(Inherited from MarshalByRefObject)
Remove(Object) Remove(Object) Remove(Object) Remove(Object)

Removes the specified DbParameter object from the collection.

RemoveAt(Int32) RemoveAt(Int32) RemoveAt(Int32) RemoveAt(Int32)

Removes the DbParameter object at the specified from the collection.

RemoveAt(String) RemoveAt(String) RemoveAt(String) RemoveAt(String)

Removes the DbParameter object with the specified name from the collection.

SetParameter(Int32, DbParameter) SetParameter(Int32, DbParameter) SetParameter(Int32, DbParameter) SetParameter(Int32, DbParameter)

Sets the DbParameter object at the specified index to a new value.

SetParameter(String, DbParameter) SetParameter(String, DbParameter) SetParameter(String, DbParameter) SetParameter(String, DbParameter)

Sets the DbParameter object with the specified name to a new value.

ToString() ToString() ToString() ToString()

Returns a string that represents the current object.

(Inherited from Object)

Explicit Interface Implementations

ICollection.IsSynchronized ICollection.IsSynchronized ICollection.IsSynchronized ICollection.IsSynchronized
IDataParameterCollection.Item[String] IDataParameterCollection.Item[String] IDataParameterCollection.Item[String] IDataParameterCollection.Item[String]

Gets or sets the parameter at the specified index.

IList.IsFixedSize IList.IsFixedSize IList.IsFixedSize IList.IsFixedSize
IList.IsReadOnly IList.IsReadOnly IList.IsReadOnly IList.IsReadOnly
IList.Item[Int32] IList.Item[Int32] IList.Item[Int32] IList.Item[Int32]

Gets or sets the element at the specified index.

Extension Methods

Cast<TResult>(IEnumerable) Cast<TResult>(IEnumerable) Cast<TResult>(IEnumerable) Cast<TResult>(IEnumerable)

Casts the elements of an IEnumerable to the specified type.

OfType<TResult>(IEnumerable) OfType<TResult>(IEnumerable) OfType<TResult>(IEnumerable) OfType<TResult>(IEnumerable)

Filters the elements of an IEnumerable based on a specified type.

AsParallel(IEnumerable) AsParallel(IEnumerable) AsParallel(IEnumerable) AsParallel(IEnumerable)

Enables parallelization of a query.

AsQueryable(IEnumerable) AsQueryable(IEnumerable) AsQueryable(IEnumerable) AsQueryable(IEnumerable)

Converts an IEnumerable to an IQueryable.

Applies to

See also