Google.Cloud.Spanner.Data - Class SpannerParameterCollection (5.0.0-beta03)

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

Reference documentation and code samples for the Google.Cloud.Spanner.Data class SpannerParameterCollection.

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

Inheritance

object > MarshalByRefObject > DbParameterCollection > SpannerParameterCollection

Implements

IDataParameterCollection, IList, ICollection, IEnumerable SpannerParameter, IEnumerable

Inherited Members

DbParameterCollection.this[int]

DbParameterCollection.this[string]

MarshalByRefObject.GetLifetimeService()

MarshalByRefObject.InitializeLifetimeService()

object.GetHashCode()

object.GetType()

object.ToString()

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`	`IEnumerableSpannerParameter` The initial parameters to include in the collection.

Properties

Count

public override int Count { get; }

Specifies the number of items in the collection.

Property Value
Type	Description
`int`	The number of items in the collection.

Overrides

DbParameterCollection.Count

IsFixedSize

public override bool IsFixedSize { get; }

Specifies whether the collection is a fixed size.

Property Value
Type	Description
`bool`	true if the collection is a fixed size; otherwise false.

Overrides

DbParameterCollection.IsFixedSize

IsReadOnly

public override bool IsReadOnly { get; }

Specifies whether the collection is read-only.

Property Value
Type	Description
`bool`	true if the collection is read-only; otherwise false.

Overrides

DbParameterCollection.IsReadOnly

IsSynchronized

public override bool IsSynchronized { get; }

Specifies whether the collection is synchronized.

Property Value
Type	Description
`bool`	true if the collection is synchronized; otherwise false.

Overrides

DbParameterCollection.IsSynchronized

SyncRoot

public override object SyncRoot { get; }

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

Property Value
Type	Description
`object`	A object to be used to synchronize access to the DbParameterCollection.

Overrides

DbParameterCollection.SyncRoot

Methods

Add(object)

public override int Add(object value)

Adds the specified DbParameter object to the DbParameterCollection.

Parameter
Name	Description
`value`	`object` The Value of the DbParameter to add to the collection.

Returns
Type	Description
`int`	The index of the DbParameter object in the collection.

Overrides

DbParameterCollection.Add(object)

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)

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

Parameter
Name	Description
`values`	`Array` An array of values of type DbParameter to add to the collection.

Overrides

DbParameterCollection.AddRange(Array)

Clear()

public override void Clear()

Removes all DbParameter values from the DbParameterCollection.

Overrides

DbParameterCollection.Clear()

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)

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

Parameter
Name	Description
`value`	`object` The Value of the DbParameter to look for in the collection.

Returns
Type	Description
`bool`	true if the DbParameter is in the collection; otherwise false.

Overrides

DbParameterCollection.Contains(object)

Contains(string)

public override bool Contains(string value)

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

Parameter
Name	Description
`value`	`string` The name of the DbParameter to look for in the collection.

Returns
Type	Description
`bool`	true if the DbParameter is in the collection; otherwise false.

Overrides

DbParameterCollection.Contains(string)

CopyTo(Array, int)

public override void CopyTo(Array array, int index)

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

Parameters
Name	Description
`array`	`Array` The array of items to copy to the collection.
`index`	`int` The index in the collection to copy the items.

Overrides

DbParameterCollection.CopyTo(Array, int)

GetEnumerator()

public override IEnumerator GetEnumerator()

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

Returns
Type	Description
`IEnumerator`	An IEnumerator that can be used to iterate through the collection.

Overrides

DbParameterCollection.GetEnumerator()

GetParameter(int)

protected override DbParameter GetParameter(int index)

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

Parameter
Name	Description
`index`	`int` The index of the DbParameter in the collection.

Returns
Type	Description
`DbParameter`	The DbParameter object at the specified index in the collection.

Overrides

DbParameterCollection.GetParameter(int)

GetParameter(string)

protected override DbParameter GetParameter(string parameterName)

Returns DbParameter the object with the specified name.

Parameter
Name	Description
`parameterName`	`string` The name of the DbParameter in the collection.

Returns
Type	Description
`DbParameter`	The DbParameter the object with the specified name.

Overrides

DbParameterCollection.GetParameter(string)

IndexOf(object)

public override int IndexOf(object value)

Returns the index of the specified DbParameter object.

Parameter
Name	Description
`value`	`object` The DbParameter object in the collection.

Returns
Type	Description
`int`	The index of the specified DbParameter object.

Overrides

DbParameterCollection.IndexOf(object)

IndexOf(string)

public override int IndexOf(string parameterName)

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

Parameter
Name	Description
`parameterName`	`string` The name of the DbParameter object in the collection.

Returns
Type	Description
`int`	The index of the DbParameter object with the specified name.

Overrides

DbParameterCollection.IndexOf(string)

Insert(int, object)

public override void Insert(int index, object value)

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

Parameters
Name	Description
`index`	`int` The index at which to insert the DbParameter object.
`value`	`object` The DbParameter object to insert into the collection.

Overrides

DbParameterCollection.Insert(int, object)

Remove(object)

public override void Remove(object value)

Removes the specified DbParameter object from the collection.

Parameter
Name	Description
`value`	`object` The DbParameter object to remove.

Overrides

DbParameterCollection.Remove(object)

RemoveAt(int)

public override void RemoveAt(int index)

Removes the DbParameter object at the specified from the collection.

Parameter
Name	Description
`index`	`int` The index where the DbParameter object is located.

Overrides

DbParameterCollection.RemoveAt(int)

RemoveAt(string)

public override void RemoveAt(string parameterName)

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

Parameter
Name	Description
`parameterName`	`string` The name of the DbParameter object to remove.

Overrides

DbParameterCollection.RemoveAt(string)

SetParameter(int, DbParameter)

protected override void SetParameter(int index, DbParameter value)

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

Parameters
Name	Description
`index`	`int` The index where the DbParameter object is located.
`value`	`DbParameter` The new DbParameter value.

Overrides

DbParameterCollection.SetParameter(int, DbParameter)

SetParameter(string, DbParameter)

protected override void SetParameter(string parameterName, DbParameter value)

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

Parameters
Name	Description
`parameterName`	`string` The name of the DbParameter object in the collection.
`value`	`DbParameter` The new DbParameter value.

Overrides

DbParameterCollection.SetParameter(string, DbParameter)