Send feedback
Class SpannerParameterCollection (3.11.0)
Stay organized with collections
Save and categorize content based on your preferences.
Version 3.11.0 keyboard_arrow_down
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.
Inherited Members
System.Data.Common.DbParameterCollection.System.Collections.IList.get_Item(System.Int32)
System.Data.Common.DbParameterCollection.System.Collections.IList.set_Item(System.Int32, System.Object)
System.Data.Common.DbParameterCollection.System.Data.IDataParameterCollection.get_Item(System.String)
System.Data.Common.DbParameterCollection.System.Data.IDataParameterCollection.set_Item(System.String, System.Object)
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.
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)
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.
Add(String, SpannerDbType, Object)
public SpannerParameter Add(string parameterName, SpannerDbType dbType, object value)
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.
AddRange(Array)
public override void AddRange(Array values)
Parameter Name Description values
Array
Overrides
Clear()
public override void Clear()
Overrides
Clone()
public SpannerParameterCollection Clone()
Contains(Object)
public override bool Contains(object value)
Parameter Name Description value
Object
Overrides
Contains(String)
public override bool Contains(string value)
Parameter Name Description value
String
Overrides
CopyTo(Array, Int32)
public override void CopyTo(Array array, int index)
Overrides
GetEnumerator()
public override IEnumerator GetEnumerator()
Overrides
GetParameter(Int32)
protected override DbParameter GetParameter(int index)
Parameter Name Description index
Int32
Overrides
GetParameter(String)
protected override DbParameter GetParameter(string parameterName)
Parameter Name Description parameterName
String
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)
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)
Overrides
SetParameter(String, DbParameter)
protected override void SetParameter(string parameterName, DbParameter value)
Overrides
Explicit Interface Implementations
IEnumerable<SpannerParameter>.GetEnumerator()
IEnumerator<SpannerParameter> IEnumerable<SpannerParameter>.GetEnumerator()
Send feedback
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License , and code samples are licensed under the Apache 2.0 License . For details, see the Google Developers Site Policies . Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-11-26 UTC.
Need to tell us more?
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-11-26 UTC."],[],[]]