Google.Cloud.Spanner.Data - Class SpannerDataAdapter (5.0.0-beta02)

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

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, params string[])

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

Initializes a new instance of the SpannerDataAdapter class with the specified

Parameters
NameDescription
connectionSpannerConnection

A connection to the Spanner database. Must not be null.

autoGeneratedCommandTablestring

The Spanner database table to use for automatically generated commands. May be null.

primaryKeysstring

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
TypeDescription
ISetstring

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
TypeDescription
string

DeleteCommand

public SpannerCommand DeleteCommand { get; set; }

The SpannerCommand used to delete rows.

Property Value
TypeDescription
SpannerCommand

InsertCommand

public SpannerCommand InsertCommand { get; set; }

The SpannerCommand used to insert rows.

Property Value
TypeDescription
SpannerCommand

SelectCommand

public SpannerCommand SelectCommand { get; set; }

The SpannerCommand used to run a SQL Query.

Property Value
TypeDescription
SpannerCommand

SpannerConnection

public SpannerConnection SpannerConnection { get; set; }

The connection to the Spanner database.

Property Value
TypeDescription
SpannerConnection

UpdateCommand

public SpannerCommand UpdateCommand { get; set; }

The SpannerCommand used to update rows.

Property Value
TypeDescription
SpannerCommand

Methods

CreateRowUpdatedEvent(DataRow, IDbCommand, StatementType, DataTableMapping)

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

Initializes a new instance of the RowUpdatedEventArgs class.

Parameters
NameDescription
dataRowDataRow

The DataRow used to update the data source.

commandIDbCommand

The IDbCommand executed during the Update(DataSet).

statementTypeStatementType

Whether the command is an UPDATE, INSERT, DELETE, or SELECT statement.

tableMappingDataTableMapping

A DataTableMapping object.

Returns
TypeDescription
RowUpdatedEventArgs

A new instance of the RowUpdatedEventArgs class.

Overrides

CreateRowUpdatingEvent(DataRow, IDbCommand, StatementType, DataTableMapping)

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

Initializes a new instance of the RowUpdatingEventArgs class.

Parameters
NameDescription
dataRowDataRow

The DataRow that updates the data source.

commandIDbCommand

The IDbCommand to execute during the Update(DataSet).

statementTypeStatementType

Whether the command is an UPDATE, INSERT, DELETE, or SELECT statement.

tableMappingDataTableMapping

A DataTableMapping object.

Returns
TypeDescription
RowUpdatingEventArgs

A new instance of the RowUpdatingEventArgs class.

Overrides

Fill(DataSet, int, int, string, IDbCommand, CommandBehavior)

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

Adds or refreshes rows in a specified range in the DataSet to match those in the data source using the DataSet and source table names, command string, and command behavior.

Parameters
NameDescription
dataSetDataSet

A DataSet to fill with records and, if necessary, schema.

startRecordint

The zero-based record number to start with.

maxRecordsint

The maximum number of records to retrieve.

srcTablestring

The name of the source table to use for table mapping.

commandIDbCommand

The SQL SELECT statement used to retrieve rows from the data source.

behaviorCommandBehavior

One of the CommandBehavior values.

Returns
TypeDescription
int

The number of rows successfully added to or refreshed in the DataSet. This does not include rows affected by statements that do not return rows.

Overrides
Exceptions
TypeDescription
InvalidOperationException

The source table is invalid.

ArgumentException

The startRecord parameter is less than 0.
-or-
The maxRecords parameter is less than 0.

Fill(DataSet, string, IDataReader, int, int)

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

Adds or refreshes rows in a specified range in the DataSet to match those in the data source using the DataSet and DataTable names.

Parameters
NameDescription
dataSetDataSet

A DataSet to fill with records.

srcTablestring

A string indicating the name of the source table.

dataReaderIDataReader

An instance of IDataReader.

startRecordint

The zero-based index of the starting record.

maxRecordsint

An integer indicating the maximum number of records.

Returns
TypeDescription
int

The number of rows successfully added to or refreshed in the DataSet. This does not include rows affected by statements that do not return rows.

Overrides

OnRowUpdated(RowUpdatedEventArgs)

protected override void OnRowUpdated(RowUpdatedEventArgs rowUpdatedEventArgs)

Raises the RowUpdated event of a .NET Framework data provider.

Parameter
NameDescription
rowUpdatedEventArgsRowUpdatedEventArgs
Overrides

OnRowUpdating(RowUpdatingEventArgs)

protected override void OnRowUpdating(RowUpdatingEventArgs rowUpdatingEventArgs)

Raises the RowUpdating event of a .NET Framework data provider.

Parameter
NameDescription
rowUpdatingEventArgsRowUpdatingEventArgs
Overrides

Events

RowUpdated

public event EventHandler<SpannerRowUpdatedEventArgs> RowUpdated

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

Event Type
TypeDescription
EventHandlerSpannerRowUpdatedEventArgs

RowUpdating

public event EventHandler<SpannerRowUpdatingEventArgs> RowUpdating

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

Event Type
TypeDescription
EventHandlerSpannerRowUpdatingEventArgs