Send feedback
Class SpannerParameter (3.7.0)
Stay organized with collections
Save and categorize content based on your preferences.
Version 3.7.0 keyboard_arrow_down
public sealed class SpannerParameter : DbParameter, IDbDataParameter, IDataParameter, ICloneable
Represents a parameter to a SpannerCommand and optionally its mapping to DataSet columns.
Namespace
Google.Cloud.Spanner.Data
Assembly
Google.Cloud.Spanner.Data.dll
Constructors
SpannerParameter()
public SpannerParameter()
Initializes a new instance of the SpannerParameter class.
SpannerParameter(String, SpannerDbType, Object, String)
public SpannerParameter ( string parameterName , SpannerDbType type , object value = null , string sourceColumn = null )
Initializes a new instance of the SpannerParameter class.
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. This value is case sensitive. Must not be null.
type
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.
sourceColumn
String
The name of the DataTable source column (SourceColumn) if this SpannerParameter is
used in a call to Update. May be null.
Properties
CommitTimestamp
public static object CommitTimestamp { get; }
Returns a value that will be replaced with a commit timestamp on insert or update.
Only suitable for Timestamp values.
Property Value Type Description Object
DbType
public override DbType DbType { get; set; }
Property Value Type Description DbType
Overrides
Direction
public override ParameterDirection Direction { get; set; }
Overrides
IsNullable
public override bool IsNullable { get; set; }
Property Value Type Description Boolean
Overrides
ParameterName
public override string ParameterName { get; set; }
Property Value Type Description String
Overrides
Size
public override int Size { get; set; }
Property Value Type Description Int32
Overrides
SourceColumn
public override string SourceColumn { get; set; }
Property Value Type Description String
Overrides
SourceColumnNullMapping
public override bool SourceColumnNullMapping { get; set; }
Property Value Type Description Boolean
Overrides
SourceVersion
public override DataRowVersion SourceVersion { get; set; }
Overrides
SpannerDbType
public SpannerDbType SpannerDbType { get; set; }
The SpannerDbType of the parameter or column. This should match the type as defined in Spanner
or as defined by the result of a SQL Query.
Value
public override object Value { get; set; }
Property Value Type Description Object
Overrides
Methods
Clone()
ResetDbType()
public override void ResetDbType()
Overrides
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-12-12 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-12-12 UTC."],[],[]]