Google Cloud Spanner v1 API - Class ExecuteBatchDmlRequest.Types.Statement (5.0.0-beta02)

public sealed class ExecuteBatchDmlRequest.Types.Statement : IMessage<ExecuteBatchDmlRequest.Types.Statement>, IEquatable<ExecuteBatchDmlRequest.Types.Statement>, IDeepCloneable<ExecuteBatchDmlRequest.Types.Statement>, IBufferMessage, IMessage

Reference documentation and code samples for the Google Cloud Spanner v1 API class ExecuteBatchDmlRequest.Types.Statement.

A single DML statement.

Inheritance

object > ExecuteBatchDmlRequest.Types.Statement

Namespace

Google.Cloud.Spanner.V1

Assembly

Google.Cloud.Spanner.V1.dll

Constructors

Statement()

public Statement()

Statement(Statement)

public Statement(ExecuteBatchDmlRequest.Types.Statement other)
Parameter
NameDescription
otherExecuteBatchDmlRequestTypesStatement

Properties

ParamTypes

public MapField<string, Type> ParamTypes { get; }

It is not always possible for Cloud Spanner to infer the right SQL type from a JSON value. For example, values of type BYTES and values of type STRING both appear in [params][google.spanner.v1.ExecuteBatchDmlRequest.Statement.params] as JSON strings.

In these cases, param_types can be used to specify the exact SQL type for some or all of the SQL statement parameters. See the definition of [Type][google.spanner.v1.Type] for more information about SQL types.

Property Value
TypeDescription
MapFieldstringType

Params

public Struct Params { get; set; }

Parameter names and values that bind to placeholders in the DML string.

A parameter placeholder consists of the @ character followed by the parameter name (for example, @firstName). Parameter names can contain letters, numbers, and underscores.

Parameters can appear anywhere that a literal value is expected. The same parameter name can be used more than once, for example:

"WHERE id > @msg_id AND id < @msg_id + 100"

It is an error to execute a SQL statement with unbound parameters.

Property Value
TypeDescription
Struct

Sql

public string Sql { get; set; }

Required. The DML string.

Property Value
TypeDescription
string