Google.Cloud.Spanner.Data - Class SpannerDataAdapter (4.1.0)

public sealed class SpannerDataAdapter : DbDataAdapter, IComponent, IDisposable, ICloneable, IDbDataAdapter, IDataAdapter

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

Represents a set of data commands and a database connection that are used to fill the DataSet and update a Spanner database.

Inheritance

Object > MarshalByRefObject > Component > DataAdapter > DbDataAdapter > SpannerDataAdapter

Implements

IComponent, IDisposable, ICloneable, IDbDataAdapter, IDataAdapter

Inherited Members

DbDataAdapter.DefaultSourceTableName

DbDataAdapter.AddToBatch(IDbCommand)

DbDataAdapter.ClearBatch()

DbDataAdapter.Dispose(Boolean)

DbDataAdapter.ExecuteBatch()

DbDataAdapter.Fill(DataSet)

DbDataAdapter.Fill(DataSet, Int32, Int32, String)

DbDataAdapter.Fill(DataSet, String)

DbDataAdapter.Fill(DataTable)

DbDataAdapter.Fill(DataTable, IDbCommand, CommandBehavior)

DbDataAdapter.Fill(DataTable[], Int32, Int32, IDbCommand, CommandBehavior)

DbDataAdapter.Fill(Int32, Int32, DataTable[])

DbDataAdapter.FillSchema(DataSet, SchemaType)

DbDataAdapter.FillSchema(DataSet, SchemaType, IDbCommand, String, CommandBehavior)

DbDataAdapter.FillSchema(DataSet, SchemaType, String)

DbDataAdapter.FillSchema(DataTable, SchemaType)

DbDataAdapter.FillSchema(DataTable, SchemaType, IDbCommand, CommandBehavior)

DbDataAdapter.GetBatchedParameter(Int32, Int32)

DbDataAdapter.GetBatchedRecordsAffected(Int32, Int32, Exception)

DbDataAdapter.GetFillParameters()

DbDataAdapter.InitializeBatching()

DbDataAdapter.ICloneable.Clone()

DbDataAdapter.TerminateBatching()

DbDataAdapter.Update(DataRow[])

DbDataAdapter.Update(DataRow[], DataTableMapping)

DbDataAdapter.Update(DataSet)

DbDataAdapter.Update(DataSet, String)

DbDataAdapter.Update(DataTable)

DbDataAdapter.FillCommandBehavior

DbDataAdapter.UpdateBatchSize

DataAdapter.CloneInternals()

DataAdapter.CreateTableMappings()

DataAdapter.Fill(DataTable, IDataReader)

DataAdapter.Fill(DataTable[], IDataReader, Int32, Int32)

DataAdapter.FillSchema(DataSet, SchemaType, String, IDataReader)

DataAdapter.FillSchema(DataTable, SchemaType, IDataReader)

DataAdapter.HasTableMappings()

DataAdapter.OnFillError(FillErrorEventArgs)

DataAdapter.ShouldSerializeTableMappings()

DataAdapter.AcceptChangesDuringFill

DataAdapter.AcceptChangesDuringUpdate

DataAdapter.ContinueUpdateOnError

DataAdapter.FillLoadOption

DataAdapter.MissingMappingAction

DataAdapter.MissingSchemaAction

DataAdapter.ReturnProviderSpecificTypes

DataAdapter.IDataAdapter.TableMappings

DataAdapter.TableMappings

DataAdapter.FillError

Component.Dispose()

Component.GetService(Type)

Component.ToString()

Component.CanRaiseEvents

Component.Container

Component.DesignMode

Component.Events

Component.Site

Component.Disposed

MarshalByRefObject.GetLifetimeService()

MarshalByRefObject.InitializeLifetimeService()

MarshalByRefObject.MemberwiseClone(Boolean)

Object.GetHashCode()

Object.GetType()

Object.MemberwiseClone()

Namespace

Google.Cloud.Spanner.Data

Assembly

Google.Cloud.Spanner.Data.dll

Constructors

SpannerDataAdapter()

public SpannerDataAdapter()

Initializes a new instance of the SpannerDataAdapter class

SpannerDataAdapter(SpannerConnection, String, String[])

public SpannerDataAdapter(SpannerConnection connection, string autoGeneratedCommandTable, params string[] primaryKeys)

Initializes a new instance of the SpannerDataAdapter class with the specified

Parameters
Name	Description
`connection`	`SpannerConnection` A connection to the Spanner database. Must not be null.
`autoGeneratedCommandTable`	`String` The Spanner database table to use for automatically generated commands. May be null.
`primaryKeys`	`String[]` The set of columns that form the primary key for `autoGeneratedCommandTable`.

Properties

AutoGeneratedCommandPrimaryKeys

public ISet<string> AutoGeneratedCommandPrimaryKeys { get; }

The set of primary keys defined for AutoGeneratedCommandTable.

Property Value
Type	Description
`ISet<String>`

AutoGeneratedCommandTable

public string AutoGeneratedCommandTable { get; set; }

The table to use for automatically built commands. If set, the SpannerDataAdapter will automatically create commands for SelectCommand, InsertCommand, UpdateCommand and DeleteCommand selecting all columns for that Table. You can choose to customize some or all of the commands and use the autogenerated commands for ones you do not modify. For example, you can set SelectCommand to be a custom SQL Query, and leave the other commands to be based on AutoGeneratedCommandTable

Property Value
Type	Description
`String`

DeleteCommand

public SpannerCommand DeleteCommand { get; set; }

The SpannerCommand used to delete rows.

Property Value
Type	Description
`SpannerCommand`

InsertCommand

public SpannerCommand InsertCommand { get; set; }

The SpannerCommand used to insert rows.

Property Value
Type	Description
`SpannerCommand`

SelectCommand

public SpannerCommand SelectCommand { get; set; }

The SpannerCommand used to run a SQL Query.

Property Value
Type	Description
`SpannerCommand`

SpannerConnection

public SpannerConnection SpannerConnection { get; set; }

The connection to the Spanner database.

Property Value
Type	Description
`SpannerConnection`

UpdateCommand

public SpannerCommand UpdateCommand { get; set; }

The SpannerCommand used to update rows.

Property Value
Type	Description
`SpannerCommand`

Methods

CreateRowUpdatedEvent(DataRow, IDbCommand, StatementType, DataTableMapping)

protected override RowUpdatedEventArgs CreateRowUpdatedEvent(DataRow dataRow, IDbCommand command, StatementType statementType, DataTableMapping tableMapping)

Parameters
Name	Description
`dataRow`	`DataRow`
`command`	`IDbCommand`
`statementType`	`StatementType`
`tableMapping`	`DataTableMapping`

Returns
Type	Description
`RowUpdatedEventArgs`

Overrides

DbDataAdapter.CreateRowUpdatedEvent(DataRow, IDbCommand, StatementType, DataTableMapping)

CreateRowUpdatingEvent(DataRow, IDbCommand, StatementType, DataTableMapping)

protected override RowUpdatingEventArgs CreateRowUpdatingEvent(DataRow dataRow, IDbCommand command, StatementType statementType, DataTableMapping tableMapping)

Parameters
Name	Description
`dataRow`	`DataRow`
`command`	`IDbCommand`
`statementType`	`StatementType`
`tableMapping`	`DataTableMapping`

Returns
Type	Description
`RowUpdatingEventArgs`

Overrides

DbDataAdapter.CreateRowUpdatingEvent(DataRow, IDbCommand, StatementType, DataTableMapping)

Fill(DataSet, Int32, Int32, String, IDbCommand, CommandBehavior)

protected override int Fill(DataSet dataSet, int startRecord, int maxRecords, string srcTable, IDbCommand command, CommandBehavior behavior)

Parameters
Name	Description
`dataSet`	`DataSet`
`startRecord`	`Int32`
`maxRecords`	`Int32`
`srcTable`	`String`
`command`	`IDbCommand`
`behavior`	`CommandBehavior`

Returns
Type	Description
`Int32`

Overrides

DbDataAdapter.Fill(DataSet, Int32, Int32, String, IDbCommand, CommandBehavior)

Fill(DataSet, String, IDataReader, Int32, Int32)

protected override int Fill(DataSet dataSet, string srcTable, IDataReader dataReader, int startRecord, int maxRecords)

Parameters
Name	Description
`dataSet`	`DataSet`
`srcTable`	`String`
`dataReader`	`IDataReader`
`startRecord`	`Int32`
`maxRecords`	`Int32`

Returns
Type	Description
`Int32`

Overrides

DataAdapter.Fill(DataSet, String, IDataReader, Int32, Int32)

OnRowUpdated(RowUpdatedEventArgs)

protected override void OnRowUpdated(RowUpdatedEventArgs rowUpdatedEventArgs)

Parameter
Name	Description
`rowUpdatedEventArgs`	`RowUpdatedEventArgs`

Overrides

DbDataAdapter.OnRowUpdated(RowUpdatedEventArgs)

OnRowUpdating(RowUpdatingEventArgs)

protected override void OnRowUpdating(RowUpdatingEventArgs rowUpdatingEventArgs)

Parameter
Name	Description
`rowUpdatingEventArgs`	`RowUpdatingEventArgs`

Overrides

DbDataAdapter.OnRowUpdating(RowUpdatingEventArgs)

Events

RowUpdated

public event EventHandler<SpannerRowUpdatedEventArgs> RowUpdated

Occurs during Update after a command is executed against the data source.

Event Type
Type	Description
`EventHandler<SpannerRowUpdatedEventArgs>`

RowUpdating

public event EventHandler<SpannerRowUpdatingEventArgs> RowUpdating

Occurs during Update before a command is executed against the data source.

Event Type
Type	Description
`EventHandler<SpannerRowUpdatingEventArgs>`

Explicit Interface Implementations

IDbDataAdapter.DeleteCommand

[Browsable(false)]
IDbCommand IDbDataAdapter.DeleteCommand { get; set; }

Returns
Type	Description
`IDbCommand`

IDbDataAdapter.InsertCommand

[Browsable(false)]
IDbCommand IDbDataAdapter.InsertCommand { get; set; }

Returns
Type	Description
`IDbCommand`

IDbDataAdapter.SelectCommand

[Browsable(false)]
IDbCommand IDbDataAdapter.SelectCommand { get; set; }

Returns
Type	Description
`IDbCommand`

IDbDataAdapter.UpdateCommand

[Browsable(false)]
IDbCommand IDbDataAdapter.UpdateCommand { get; set; }

Returns
Type	Description
`IDbCommand`