Class SpannerParameterCollection (3.12.0) 

public sealed class SpannerParameterCollection : DbParameterCollection, IDataParameterCollection, IList, ICollection, IEnumerable<SpannerParameter>, IEnumerable

Represents a collection of parameters associated with a SpannerCommand and their respective mappings to columns in a DataSet.

Inheritance

Object > MarshalByRefObject > DbParameterCollection > SpannerParameterCollection

Namespace

Google.Cloud.Spanner.Data

Assembly

Google.Cloud.Spanner.Data.dll

Constructors

SpannerParameterCollection(IEnumerable<SpannerParameter>)

public SpannerParameterCollection(IEnumerable<SpannerParameter> initialParameters = null)

Initializes a new SpannerParameterCollection with the given set of optional SpannerParameter objects.

Parameter
Name Description
initialParameters IEnumerable<SpannerParameter>

The initial parameters to include in the collection.

Properties

Count

public override int Count { get; }
Property Value
Type Description
Int32
Overrides

IsFixedSize

public override bool IsFixedSize { get; }
Property Value
Type Description
Boolean
Overrides

IsReadOnly

public override bool IsReadOnly { get; }
Property Value
Type Description
Boolean
Overrides

IsSynchronized

public override bool IsSynchronized { get; }
Property Value
Type Description
Boolean
Overrides

SyncRoot

public override object SyncRoot { get; }
Property Value
Type Description
Object
Overrides

Methods

Add(Object)

public override int Add(object value)
Parameter
Name Description
value Object
Returns
Type Description
Int32
Overrides

Add(String, SpannerDbType)

public SpannerParameter Add(string parameterName, SpannerDbType dbType)

Adds a new SpannerParameter to the SpannerParameterCollection.

Parameters
Name Description
parameterName String

The name of the parameter. For Insert, Update and Delete commands, this name should be the name of a valid Column in a Spanner table. In Select commands, this name should be the name of a parameter used in the SQL Query. Must not be null
dbType SpannerDbType

One of the SpannerDbType values that indicates the type of the parameter. Must not be null.
Returns
Type Description
SpannerParameter

The parameter which has been added.

Add(String, SpannerDbType, Object)

public SpannerParameter Add(string parameterName, SpannerDbType dbType, object value)

Adds a new SpannerParameter to the SpannerParameterCollection

Parameters
Name Description
parameterName String

The name of the parameter. For Insert, Update and Delete commands, this name should be the name of a valid Column in a Spanner table. In Select commands, this name should be the name of a parameter used in the SQL Query. Must not be null.
dbType SpannerDbType

One of the SpannerDbType values that indicates the type of the parameter. Must not be null.
value Object

An object that is the value of the SpannerParameter. May be null.
Returns
Type Description
SpannerParameter

The parameter which has been added.

AddRange(Array)

public override void AddRange(Array values)
Parameter
Name Description
values Array
Overrides

Clear()

public override void Clear()
Overrides

Clone()

public SpannerParameterCollection Clone()

Clones the collection.

Returns
Type Description
SpannerParameterCollection

A cloned copy of this instance.

Contains(Object)

public override bool Contains(object value)
Parameter
Name Description
value Object
Returns
Type Description
Boolean
Overrides

Contains(String)

public override bool Contains(string value)
Parameter
Name Description
value String
Returns
Type Description
Boolean
Overrides

CopyTo(Array, Int32)

public override void CopyTo(Array array, int index)
Parameters
Name Description
array Array
index Int32
Overrides

GetEnumerator()

public override IEnumerator GetEnumerator()
Returns
Type Description
IEnumerator
Overrides

GetParameter(Int32)

protected override DbParameter GetParameter(int index)
Parameter
Name Description
index Int32
Returns
Type Description
DbParameter
Overrides

GetParameter(String)

protected override DbParameter GetParameter(string parameterName)
Parameter
Name Description
parameterName String
Returns
Type Description
DbParameter
Overrides

IndexOf(Object)

public override int IndexOf(object value)
Parameter
Name Description
value Object
Returns
Type Description
Int32
Overrides

IndexOf(String)

public override int IndexOf(string parameterName)
Parameter
Name Description
parameterName String
Returns
Type Description
Int32
Overrides

Insert(Int32, Object)

public override void Insert(int index, object value)
Parameters
Name Description
index Int32
value Object
Overrides

Remove(Object)

public override void Remove(object value)
Parameter
Name Description
value Object
Overrides

RemoveAt(Int32)

public override void RemoveAt(int index)
Parameter
Name Description
index Int32
Overrides

RemoveAt(String)

public override void RemoveAt(string parameterName)
Parameter
Name Description
parameterName String
Overrides

SetParameter(Int32, DbParameter)

protected override void SetParameter(int index, DbParameter value)
Parameters
Name Description
index Int32
value DbParameter
Overrides

SetParameter(String, DbParameter)

protected override void SetParameter(string parameterName, DbParameter value)
Parameters
Name Description
parameterName String
value DbParameter
Overrides

Explicit Interface Implementations

IEnumerable<SpannerParameter>.GetEnumerator()

IEnumerator<SpannerParameter> IEnumerable<SpannerParameter>.GetEnumerator()
Returns
Type Description
IEnumerator<SpannerParameter>