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

public sealed class QueryOptions : IEquatable<QueryOptions>

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

Immutable class representing query options.

Inheritance

object > QueryOptions

Namespace

Google.Cloud.Spanner.Data

Assembly

Google.Cloud.Spanner.Data.dll

Properties

Empty

public static QueryOptions Empty { get; }

Creates query options without specifying any options.

Property Value
Type Description
QueryOptions

OptimizerStatisticsPackage

public string OptimizerStatisticsPackage { get; }

The query optimizer statistics package configured in the options.

Property Value
Type Description
string

OptimizerVersion

public string OptimizerVersion { get; }

The query optimizer version configured in the options.

Property Value
Type Description
string

Methods

FromProto(QueryOptions)

public static QueryOptions FromProto(ExecuteSqlRequest.Types.QueryOptions proto)

Set query options from the given proto.

Parameter
Name Description
proto Google.Cloud.Spanner.V1.ExecuteSqlRequestGoogle.Cloud.Spanner.V1.ExecuteSqlRequest.TypesGoogle.Cloud.Spanner.V1.ExecuteSqlRequest.Types.QueryOptions

The proto to construct QueryOptions from.

Returns
Type Description
QueryOptions
Remarks

The given proto should not be null. The given proto is cloned.

GetHashCode()

public override int GetHashCode()

Serves as the default hash function.

Returns
Type Description
int

A hash code for the current object.

Overrides

ToProto()

public ExecuteSqlRequest.Types.QueryOptions ToProto()

Get proto version of the query options.

Returns
Type Description
Google.Cloud.Spanner.V1.ExecuteSqlRequestGoogle.Cloud.Spanner.V1.ExecuteSqlRequest.TypesGoogle.Cloud.Spanner.V1.ExecuteSqlRequest.Types.QueryOptions

WithOptimizerStatisticsPackage(string)

public QueryOptions WithOptimizerStatisticsPackage(string optimizerStatisticsPackage)

Clones the options and sets the optimizer statistics package to the given value.

Parameter
Name Description
optimizerStatisticsPackage string

Optimizer statistics package to set.

Returns
Type Description
QueryOptions

A clone of the options with the updated optimizer statistics package.

Remarks

The parameter allows individual queries to pick different query optimizer statistics packages.

Specifying "latest" as a value instructs Cloud Spanner to use the latest supported query optimizer statistics package. If not specified, Cloud Spanner uses the optimizer statistics package set at the database level options. Any other supported statistics package value overrides the default optimizer statistics package for query execution.

WithOptimizerVersion(string)

public QueryOptions WithOptimizerVersion(string optimizerVersion)

Clones the options and sets the optimizer version to the given value.

Parameter
Name Description
optimizerVersion string

Optimizer version to set.

Returns
Type Description
QueryOptions

A clone of the options with the updated optimizer version.

Remarks

The parameter allows individual queries to pick different query optimizer versions.

Specifying "latest" as a value instructs Cloud Spanner to use the latest supported query optimizer version. If not specified, Cloud Spanner uses optimizer version set at the database level options. Any other positive integer (from the list of supported optimizer versions) overrides the default optimizer version for query execution.