public sealed class Statement : IMessage<ExecuteBatchDmlRequest.Types.Statement>, IEquatable<ExecuteBatchDmlRequest.Types.Statement>, IDeepCloneable<ExecuteBatchDmlRequest.Types.Statement>, IBufferMessage, IMessageA single DML statement.
Implements
IMessage<ExecuteBatchDmlRequest.Types.Statement>, IEquatable<ExecuteBatchDmlRequest.Types.Statement>, IDeepCloneable<ExecuteBatchDmlRequest.Types.Statement>, IBufferMessage, IMessageNamespace
Google.Cloud.Spanner.V1Assembly
Google.Cloud.Spanner.V1.dll
Constructors
Statement()
public Statement()Statement(ExecuteBatchDmlRequest.Types.Statement)
public Statement(ExecuteBatchDmlRequest.Types.Statement other)| Parameter | |
|---|---|
| Name | Description |
other |
ExecuteBatchDmlRequest.Types.Statement |
Properties
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 | |
|---|---|
| Type | Description |
Struct |
|
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 | |
|---|---|
| Type | Description |
MapField<String, Type> |
|
Sql
public string Sql { get; set; }Required. The DML string.
| Property Value | |
|---|---|
| Type | Description |
String |
|