Class DuckDBParameterCollection

Namespace

DuckDB.NET.Data

Assembly

DuckDB.NET.Data.dll

public class DuckDBParameterCollection : DbParameterCollection, IDataParameterCollection, IList, ICollection, IEnumerable

Inheritance

object

MarshalByRefObject

DbParameterCollection

DuckDBParameterCollection

Implements

IDataParameterCollection

IList

ICollection

IEnumerable

Inherited Members

MarshalByRefObject.GetLifetimeService()

MarshalByRefObject.InitializeLifetimeService()

MarshalByRefObject.MemberwiseClone(bool)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Properties

Count

Specifies the number of items in the collection.

public override int Count { get; }

Property Value

int

The number of items in the collection.

this[int]

public DuckDBParameter this[int index] { get; set; }

Parameters

index int

Property Value

DuckDBParameter

this[string]

public DuckDBParameter this[string parameterName] { get; set; }

Parameters

parameterName string

Property Value

DuckDBParameter

SyncRoot

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

public override object SyncRoot { get; }

Property Value

object

A object to be used to synchronize access to the DbParameterCollection.

Methods

Add(DuckDBParameter)

public int Add(DuckDBParameter value)

Parameters

value DuckDBParameter

Returns

int

Add(object)

Adds the specified DbParameter object to the DbParameterCollection.

public override int Add(object value)

Parameters

value object

The Value of the DbParameter to add to the collection.

Returns

int

The index of the DbParameter object in the collection.

AddRange(Array)

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

public override void AddRange(Array values)

Parameters

values Array

An array of values of type DbParameter to add to the collection.

AddRange(IEnumerable<DuckDBParameter>)

public void AddRange(IEnumerable<DuckDBParameter> values)

Parameters

values IEnumerable<DuckDBParameter>

Clear()

Removes all DbParameter values from the DbParameterCollection.

public override void Clear()

Contains(DuckDBParameter)

public bool Contains(DuckDBParameter value)

Parameters

value DuckDBParameter

Returns

bool

Contains(object)

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

public override bool Contains(object value)

Parameters

value object

The Value of the DbParameter to look for in the collection.

Returns

bool

true if the DbParameter is in the collection; otherwise false.

Contains(string)

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

public override bool Contains(string value)

Parameters

value string

The name of the DbParameter to look for in the collection.

Returns

bool

true if the DbParameter is in the collection; otherwise false.

CopyTo(DuckDBParameter[], int)

public void CopyTo(DuckDBParameter[] array, int index)

Parameters

array DuckDBParameter[]

index int

CopyTo(Array, int)

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

public override void CopyTo(Array array, int index)

Parameters

array Array

The array of items to copy to the collection.

index int

The index in the collection to copy the items.

GetEnumerator()

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

public override IEnumerator GetEnumerator()

Returns

IEnumerator

An IEnumerator that can be used to iterate through the collection.

GetParameter(int)

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

protected override DbParameter GetParameter(int index)

Parameters

index int

The index of the DbParameter in the collection.

Returns

DbParameter

The DbParameter object at the specified index in the collection.

GetParameter(string)

Returns DbParameter the object with the specified name.

protected override DbParameter GetParameter(string parameterName)

Parameters

parameterName string

The name of the DbParameter in the collection.

Returns

DbParameter

The DbParameter the object with the specified name.

IndexOf(DuckDBParameter)

public int IndexOf(DuckDBParameter value)

Parameters

value DuckDBParameter

Returns

int

IndexOf(object)

Returns the index of the specified DbParameter object.

public override int IndexOf(object value)

Parameters

value object

The DbParameter object in the collection.

Returns

int

The index of the specified DbParameter object.

IndexOf(string)

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

public override int IndexOf(string parameterName)

Parameters

parameterName string

The name of the DbParameter object in the collection.

Returns

int

The index of the DbParameter object with the specified name.

Insert(int, DuckDBParameter)

public void Insert(int index, DuckDBParameter value)

Parameters

index int

value DuckDBParameter

Insert(int, object)

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

public override void Insert(int index, object value)

Parameters

index int

The index at which to insert the DbParameter object.

value object

The DbParameter object to insert into the collection.

Remove(DuckDBParameter)

public void Remove(DuckDBParameter value)

Parameters

value DuckDBParameter

Remove(object)

Removes the specified DbParameter object from the collection.

public override void Remove(object value)

Parameters

value object

The DbParameter object to remove.

RemoveAt(int)

Removes the DbParameter object at the specified from the collection.

public override void RemoveAt(int index)

Parameters

index int

The index where the DbParameter object is located.

RemoveAt(string)

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

public override void RemoveAt(string parameterName)

Parameters

parameterName string

The name of the DbParameter object to remove.

SetParameter(int, DbParameter)

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

protected override void SetParameter(int index, DbParameter value)

Parameters

index int

The index where the DbParameter object is located.

value DbParameter

The new DbParameter value.

SetParameter(string, DbParameter)

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

protected override void SetParameter(string parameterName, DbParameter value)

Parameters

parameterName string

The name of the DbParameter object in the collection.

value DbParameter

The new DbParameter value.