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.
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 |
|---|
| 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; }
AutoGeneratedCommandTable
public string AutoGeneratedCommandTable { get; set; }
| Property Value |
|---|
| Type | Description |
string | |
DeleteCommand
public SpannerCommand DeleteCommand { get; set; }
InsertCommand
public SpannerCommand InsertCommand { get; set; }
SelectCommand
public SpannerCommand SelectCommand { get; set; }
SpannerConnection
public SpannerConnection SpannerConnection { get; set; }
The connection to the Spanner database.
UpdateCommand
public SpannerCommand UpdateCommand { get; set; }
Methods
CreateRowUpdatedEvent(DataRow, IDbCommand, StatementType, DataTableMapping)
protected override RowUpdatedEventArgs CreateRowUpdatedEvent(DataRow dataRow, IDbCommand command, StatementType statementType, DataTableMapping tableMapping)
Overrides
CreateRowUpdatingEvent(DataRow, IDbCommand, StatementType, DataTableMapping)
protected override RowUpdatingEventArgs CreateRowUpdatingEvent(DataRow dataRow, IDbCommand command, StatementType statementType, DataTableMapping tableMapping)
Overrides
Fill(DataSet, int, int, string, IDbCommand, CommandBehavior)
protected override int Fill(DataSet dataSet, int startRecord, int maxRecords, string srcTable, IDbCommand command, CommandBehavior behavior)
| Returns |
|---|
| Type | Description |
int | |
Overrides
Fill(DataSet, string, IDataReader, int, int)
protected override int Fill(DataSet dataSet, string srcTable, IDataReader dataReader, int startRecord, int maxRecords)
| Returns |
|---|
| Type | Description |
int | |
Overrides
OnRowUpdated(RowUpdatedEventArgs)
protected override void OnRowUpdated(RowUpdatedEventArgs rowUpdatedEventArgs)
Overrides
OnRowUpdating(RowUpdatingEventArgs)
protected override void OnRowUpdating(RowUpdatingEventArgs rowUpdatingEventArgs)
Overrides
Events
RowUpdated
public event EventHandler<SpannerRowUpdatedEventArgs> RowUpdated
Occurs during Update after a command is executed against the data source.
RowUpdating
public event EventHandler<SpannerRowUpdatingEventArgs> RowUpdating
Occurs during Update before a command is executed against the data source.
