Class MySqlDataAdapter

Represents a set of data commands and a database connection that are used to fill a dataset and update a MySQL database. This class cannot be inherited.

Inheritance

Object

MySqlDataAdapter

Implements

Namespace: MySql.Data.MySqlClient

Assembly: MySql.Data.dll

Version: 8.0.33

Syntax

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

Remarks

The MySqlDataAdapter, serves as a bridge between a DataSet and MySQL for retrieving and saving data. The MySqlDataAdapter provides this bridge by mapping Fill(DataSet), which changes the data in the DataSet to match the data in the data source, and Update(DataSet), which changes the data in the data source to match the data in the DataSet, using the appropriate SQL statements against the data source.

When the MySqlDataAdapter fills a DataSet, it will create the necessary tables and columns for the returned data if they do not already exist. However, primary key information will not be included in the implicitly created schema unless the MissingSchemaAction property is set to AddWithKey. You may also have the MySqlDataAdapter create the schema of the DataSet, including primary key information, before filling it with data using FillSchema(DataTable, SchemaType).

MySqlDataAdapter is used in conjunction with MySqlConnection and MySqlCommand to increase performance when connecting to a MySQL database.

The MySqlDataAdapter also includes the SelectCommand, InsertCommand, DeleteCommand, UpdateCommand, and TableMappings properties to facilitate the loading and updating of data.

When an instance of MySqlDataAdapter is created, the read/write properties are set to initial values. For a list of these values, see the MySqlDataAdapter constructor.

note

Please be aware that the DataColumn class allows only Int16, Int32, and Int64 to have the AutoIncrement property set. If you plan to use autoincremement columns with MySQL, you should consider using signed integer columns.

Examples

The following example creates a MySqlCommand and a MySqlConnection. The MySqlConnection is opened and set as the Connection for the MySqlCommand. The example then calls ExecuteNonQuery(), and closes the connection. To accomplish this, the ExecuteNonQuery() is passed a connection string and a query string that is a SQL INSERT statement.

  public DataSet SelectRows(DataSet dataset,string connection,string query)
  {
    MySqlConnection conn = new MySqlConnection(connection);
    MySqlDataAdapter adapter = new MySqlDataAdapter();
    adapter.SelectCommand = new MySqlCommand(query, conn);
    adapter.Fill(dataset);
    return dataset;
  }

Constructors

MySqlDataAdapter()

Initializes a new instance of the MySqlDataAdapter class.

Declaration

public MySqlDataAdapter()

Remarks

When an instance of MySqlDataAdapter is created, the following read/write properties are set to the following initial values.

Properties	Initial Value
MissingMappingAction	Passthrough
MissingSchemaAction	Add

You can change the value of any of these properties through a separate call to the property.

MySqlDataAdapter(MySqlCommand)

Initializes a new instance of the MySqlDataAdapter class with the specified MySqlCommand as the SelectCommand property.

Declaration

public MySqlDataAdapter(MySqlCommand selectCommand)

Parameters

Type	Name	Description
MySqlCommand	selectCommand	MySqlCommand that is a SQL SELECT statement or stored procedure and is set as the SelectCommand property of the MySqlDataAdapter.

MySqlDataAdapter(String, MySqlConnection)

Initializes a new instance of the MySqlDataAdapter class with a SelectCommand and a MySqlConnection object.

Declaration

public MySqlDataAdapter(string selectCommandText, MySqlConnection connection)

Parameters

Type	Name	Description
String	selectCommandText	A String that is a SQL SELECT statement or stored procedure to be used by the SelectCommand property of the MySqlDataAdapter.
MySqlConnection	connection	A MySqlConnection that represents the connection.

Remarks

This implementation of the MySqlDataAdapter opens and closes a MySqlConnection if it is not already open. This can be useful in a an application that must call the Fill(DataSet) method for two or more MySqlDataAdapter objects. If the MySqlConnection is already open, you must explicitly call Close() or Dispose() to close it.

MySqlDataAdapter(String, String)

Initializes a new instance of the MySqlDataAdapter class with a SelectCommand and a connection string.

Declaration

public MySqlDataAdapter(string selectCommandText, string selectConnString)

Parameters

Type	Name	Description
String	selectCommandText	A String that is a SQL SELECT statement or stored procedure to be used by the SelectCommand property of the MySqlDataAdapter.
String	selectConnString	The connection string

Properties

DeleteCommand

Gets or sets a SQL statement or stored procedure used to delete records from the data set.

Declaration

public MySqlCommand DeleteCommand { get; set; }

Property Value

Type	Description
MySqlCommand	A MySqlCommand used during Update(DataSet) to delete records in the database that correspond to deleted rows in the DataSet.

Remarks

During Update(DataSet), if this property is not set and primary key information is present in the DataSet, the DeleteCommand can be generated automatically if you set the SelectCommand property and use the MySqlCommandBuilder. Then, any additional commands that you do not set are generated by the MySqlCommandBuilder. This generation logic requires key column information to be present in the DataSet.

When DeleteCommand is assigned to a previously created MySqlCommand, the MySqlCommand is not cloned. The DeleteCommand maintains a reference to the previously created MySqlCommand object.

InsertCommand

Gets or sets a SQL statement or stored procedure used to insert records into the data set.

Declaration

public MySqlCommand InsertCommand { get; set; }

Property Value

Type	Description
MySqlCommand	A MySqlCommand used during Update(DataSet) to insert records into the database that correspond to new rows in the DataSet.

Remarks

During Update(DataSet), if this property is not set and primary key information is present in the DataSet, the InsertCommand can be generated automatically if you set the SelectCommand property and use the MySqlCommandBuilder. Then, any additional commands that you do not set are generated by the MySqlCommandBuilder. This generation logic requires key column information to be present in the DataSet.

When InsertCommand is assigned to a previously created MySqlCommand, the MySqlCommand is not cloned. The InsertCommand maintains a reference to the previously created MySqlCommand object.

note

If execution of this command returns rows, these rows may be added to the DataSet depending on how you set the UpdatedRowSource property of the MySqlCommand object.

SelectCommand

Gets or sets a SQL statement or stored procedure used to select records in the data source.

Declaration

public MySqlCommand SelectCommand { get; set; }

Property Value

Type	Description
MySqlCommand	A MySqlCommand used during Fill(DataSet) to select records from the database for placement in the DataSet.

Remarks

When SelectCommand is assigned to a previously created MySqlCommand, the MySqlCommand is not cloned. The SelectCommand maintains a reference to the previously created MySqlCommand object.

If the SelectCommand does not return any rows, no tables are added to the DataSet, and no exception is raised.

UpdateBatchSize

Gets or sets a value that enables or disables batch processing support, and specifies the number of commands that can be executed in a batch.

Declaration

public override int UpdateBatchSize { get; set; }

Property Value

Type	Description
Int32

Overrides

DbDataAdapter.UpdateBatchSize

Remarks

Returns the number of rows to process for each batch.

Value is	Effect
0	There is no limit on the batch size.
1	Disables batch updating.
> 1	Changes are sent using batches of UpdateBatchSize operations at a time.

When setting this to a value other than 1, all the commands associated with the MySqlDataAdapter must have their UpdateRowSource property set to None or OutputParameters. An exception will be thrown otherwise.

UpdateCommand

Gets or sets a SQL statement or stored procedure used to updated records in the data source.

Declaration

public MySqlCommand UpdateCommand { get; set; }

Property Value

Type	Description
MySqlCommand	A MySqlCommand used during Update(DataSet) to update records in the database with data from the DataSet.

Remarks

During Update(DataSet), if this property is not set and primary key information is present in the DataSet, the UpdateCommand can be generated automatically if you set the SelectCommand property and use the MySqlCommandBuilder. Then, any additional commands that you do not set are generated by the MySqlCommandBuilder. This generation logic requires key column information to be present in the DataSet.

When UpdateCommand is assigned to a previously created MySqlCommand, the MySqlCommand is not cloned. The UpdateCommand maintains a reference to the previously created MySqlCommand object.

note

If execution of this command returns rows, these rows may be merged with the DataSet depending on how you set the UpdatedRowSource property of the MySqlCommand object.

Methods

AddToBatch(IDbCommand)

Adds a IDbCommand to the current batch.

Declaration

protected override int AddToBatch(IDbCommand command)

Parameters

Type	Name	Description
IDbCommand	command	The IDbCommand to add to the batch.

Returns

Type	Description
Int32	The number of commands in the batch before adding the IDbCommand.

Overrides

DbDataAdapter.AddToBatch(IDbCommand)

ClearBatch()

Removes all IDbCommand objects from the batch.

Declaration

protected override void ClearBatch()

Overrides

DbDataAdapter.ClearBatch()

CreateRowUpdatedEvent(DataRow, IDbCommand, StatementType, DataTableMapping)

Overridden. See CreateRowUpdatedEvent(DataRow, IDbCommand, StatementType, DataTableMapping).

Declaration

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

Parameters

Type	Name	Description
DataRow	dataRow
IDbCommand	command
StatementType	statementType
DataTableMapping	tableMapping

Returns

Type	Description
RowUpdatedEventArgs

Overrides

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

CreateRowUpdatingEvent(DataRow, IDbCommand, StatementType, DataTableMapping)

Initializes a new instance of the RowUpdatingEventArgs class.

Declaration

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

Parameters

Type	Name	Description
DataRow	dataRow	The DataRow that updates the data source.
IDbCommand	command	The IDbCommand to execute during the Update(DataSet).
StatementType	statementType	Whether the command is an UPDATE, INSERT, DELETE, or SELECT statement.
DataTableMapping	tableMapping	A DataTableMapping object.

Returns

Type	Description
RowUpdatingEventArgs

Overrides

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

ExecuteBatch()

Executes the current batch.

Declaration

protected override int ExecuteBatch()

Returns

Type	Description
Int32	The return value from the last command in the batch.

Overrides

DbDataAdapter.ExecuteBatch()

FillAsync(DataSet)

Asynchronous version of the Fill(DataSet) method.

Declaration

public Task<int> FillAsync(DataSet dataSet)

Parameters

Type	Name	Description
DataSet	dataSet	The DataSet to fill records with.

Returns

Type	Description
Task<Int32>	The number of rows successfully added to or refreshed in the DataSet.

FillAsync(DataSet, Int32, Int32, String)

Asynchronous version of the Fill(DataSet, Int32, Int32, String) method.

Declaration

public Task<int> FillAsync(DataSet dataSet, int startRecord, int maxRecords, string srcTable)

Parameters

Type	Name	Description
DataSet	dataSet	The DataSet to fill with records.
Int32	startRecord	The start record.
Int32	maxRecords	The max number of affected records.
String	srcTable	The name of the source table to use for table mapping.

Returns

Type	Description
Task<Int32>	The number of rows successfully added to or refreshed in the DataSet.

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

Asynchronous version of the Fill(DataSet, Int32, Int32, String, IDbCommand, CommandBehavior) method.

Declaration

public Task<int> FillAsync(DataSet dataSet, int startRecord, int maxRecords, string srcTable, IDbCommand command, CommandBehavior behavior)

Parameters

Type	Name	Description
DataSet	dataSet	The DataSet to fill with records.
Int32	startRecord	The start record.
Int32	maxRecords	The max number of affected records.
String	srcTable	The name of the source table to use for table mapping.
IDbCommand	command	The SQL SELECT statement used to retrieve rows from the data source.
CommandBehavior	behavior	One of the CommandBehavior values.

Returns

Type	Description
Task<Int32>	The number of rows successfully added to or refreshed in the DataTable.

FillAsync(DataSet, Int32, Int32, String, IDbCommand, CommandBehavior, CancellationToken)

Asynchronous version of the Fill(DataSet, Int32, Int32, String, IDbCommand, CommandBehavior) method.

Declaration

public Task<int> FillAsync(DataSet dataSet, int startRecord, int maxRecords, string srcTable, IDbCommand command, CommandBehavior behavior, CancellationToken cancellationToken)

Parameters

Type	Name	Description
DataSet	dataSet	The DataSet to fill with records.
Int32	startRecord	The start record.
Int32	maxRecords	The max number of affected records.
String	srcTable	The name of the source table to use for table mapping.
IDbCommand	command	The SQL SELECT statement used to retrieve rows from the data source.
CommandBehavior	behavior	One of the CommandBehavior values.
CancellationToken	cancellationToken	The cancellation token.

Returns

Type	Description
Task<Int32>	The number of rows successfully added to or refreshed in the DataTable.

FillAsync(DataSet, Int32, Int32, String, CancellationToken)

Asynchronous version of the Fill(DataSet, Int32, Int32, String) method.

Declaration

public Task<int> FillAsync(DataSet dataSet, int startRecord, int maxRecords, string srcTable, CancellationToken cancellationToken)

Parameters

Type	Name	Description
DataSet	dataSet	The DataSet to fill with records.
Int32	startRecord	The start record.
Int32	maxRecords	The max number of affected records.
String	srcTable	The name of the source table to use for table mapping.
CancellationToken	cancellationToken	The cancellation token.

Returns

Type	Description
Task<Int32>	The number of rows successfully added to or refreshed in the DataSet.

FillAsync(DataSet, String)

Asynchronous version of the Fill(DataSet, String) method.

Declaration

public Task<int> FillAsync(DataSet dataSet, string srcTable)

Parameters

Type	Name	Description
DataSet	dataSet	The DataSet to fill with records.
String	srcTable	The name of the source table to use for table mapping.

Returns

Type	Description
Task<Int32>	The number of rows successfully added to or refreshed in the DataSet.

FillAsync(DataSet, String, IDataReader, Int32, Int32)

Asynchronous version of the Fill(DataSet, Int32, Int32, String) method.

Declaration

public Task<int> FillAsync(DataSet dataSet, string srcTable, IDataReader dataReader, int startRecord, int maxRecords)

Parameters

Type	Name	Description
DataSet	dataSet	The DataSet to fill with records.
String	srcTable	The name of the source table to use for table mapping.
IDataReader	dataReader	An instance of IDataReader.
Int32	startRecord	The start record.
Int32	maxRecords	The max number of affected records.

Returns

Type	Description
Task<Int32>	The number of rows successfully added to or refreshed in the DataSet.

FillAsync(DataSet, String, IDataReader, Int32, Int32, CancellationToken)

Asynchronous version of the Fill(DataSet, Int32, Int32, String) method.

Declaration

public Task<int> FillAsync(DataSet dataSet, string srcTable, IDataReader dataReader, int startRecord, int maxRecords, CancellationToken cancellationToken)

Parameters

Type	Name	Description
DataSet	dataSet	The DataSet to fill with records.
String	srcTable	The name of the source table to use for table mapping.
IDataReader	dataReader	An instance of IDataReader.
Int32	startRecord	The start record.
Int32	maxRecords	The max number of affected records.
CancellationToken	cancellationToken	The cancellation token.

Returns

Type	Description
Task<Int32>	The number of rows successfully added to or refreshed in the DataSet.

FillAsync(DataSet, String, CancellationToken)

Asynchronous version of the Fill(DataSet, String) method.

Declaration

public Task<int> FillAsync(DataSet dataSet, string srcTable, CancellationToken cancellationToken)

Parameters

Type	Name	Description
DataSet	dataSet	The DataSet to fill with records.
String	srcTable	The name of the source table to use for table mapping.
CancellationToken	cancellationToken	The cancellation token.

Returns

Type	Description
Task<Int32>	The number of rows successfully added to or refreshed in the DataSet.

FillAsync(DataSet, CancellationToken)

Asynchronous version of the Fill(DataSet) method.

Declaration

public Task<int> FillAsync(DataSet dataSet, CancellationToken cancellationToken)

Parameters

Type	Name	Description
DataSet	dataSet	The DataSet to fill records with.
CancellationToken	cancellationToken	The cancellation token.

Returns

Type	Description
Task<Int32>	The number of rows successfully added to or refreshed in the DataSet.

FillAsync(DataTable)

Asynchronous version of the Fill(DataTable) method.

Declaration

public Task<int> FillAsync(DataTable dataTable)

Parameters

Type	Name	Description
DataTable	dataTable	The name of the DataTable to use for table mapping.

Returns

Type	Description
Task<Int32>	The number of rows successfully added to or refreshed in the DataTable.

FillAsync(DataTable, IDataReader)

Asynchronous version of the Fill(DataTable) method.

Declaration

public Task<int> FillAsync(DataTable dataTable, IDataReader dataReader)

Parameters

Type	Name	Description
DataTable	dataTable	The DataTable to fill with records.
IDataReader	dataReader	An instance of IDataReader.

Returns

Type	Description
Task<Int32>	The number of rows successfully added to or refreshed in the DataTable.

FillAsync(DataTable, IDataReader, CancellationToken)

Asynchronous version of the Fill(DataTable) method.

Declaration

public Task<int> FillAsync(DataTable dataTable, IDataReader dataReader, CancellationToken cancellationToken)

Parameters

Type	Name	Description
DataTable	dataTable	The DataTable to fill with records.
IDataReader	dataReader	An instance of IDataReader.
CancellationToken	cancellationToken	The cancellation token.

Returns

Type	Description
Task<Int32>	The number of rows successfully added to or refreshed in the DataTable.

FillAsync(DataTable, IDbCommand, CommandBehavior)

Asynchronous version of the Fill(DataTable, IDbCommand, CommandBehavior) method.

Declaration

public Task<int> FillAsync(DataTable dataTable, IDbCommand command, CommandBehavior behavior)

Parameters

Type	Name	Description
DataTable	dataTable	The DataTable to fill with records.
IDbCommand	command	The SQL SELECT statement used to retrieve rows from the data source.
CommandBehavior	behavior	One of the CommandBehavior values.

Returns

Type	Description
Task<Int32>	The number of rows successfully added to or refreshed in the DataTable.

FillAsync(DataTable, IDbCommand, CommandBehavior, CancellationToken)

Asynchronous version of the Fill(DataTable, IDbCommand, CommandBehavior) method.

Declaration

public Task<int> FillAsync(DataTable dataTable, IDbCommand command, CommandBehavior behavior, CancellationToken cancellationToken)

Parameters

Type	Name	Description
DataTable	dataTable	The DataTable to fill with records.
IDbCommand	command	The SQL SELECT statement used to retrieve rows from the data source.
CommandBehavior	behavior	One of the CommandBehavior values.
CancellationToken	cancellationToken	The cancellation token.

Returns

Type	Description
Task<Int32>	The number of rows successfully added to or refreshed in the DataTable.

FillAsync(DataTable, CancellationToken)

Asynchronous version of the Fill(DataTable) method.

Declaration

public Task<int> FillAsync(DataTable dataTable, CancellationToken cancellationToken)

Parameters

Type	Name	Description
DataTable	dataTable	The name of the DataTable to use for table mapping.
CancellationToken	cancellationToken	The cancellation token.

Returns

Type	Description
Task<Int32>	The number of rows successfully added to or refreshed in the DataTable.

FillAsync(DataTable[], Int32, Int32, IDbCommand, CommandBehavior)

Asynchronous version of the Fill(DataTable[], Int32, Int32, IDbCommand, CommandBehavior) method.

Declaration

public Task<int> FillAsync(DataTable[] dataTables, int startRecord, int maxRecords, IDbCommand command, CommandBehavior behavior)

Parameters

Type	Name	Description
DataTable[]	dataTables	The DataTables to fill with records.
Int32	startRecord	The start record.
Int32	maxRecords	The max number of affected records.
IDbCommand	command	The SQL SELECT statement used to retrieve rows from the data source.
CommandBehavior	behavior	One of the CommandBehavior values.

Returns

Type	Description
Task<Int32>	The number of rows successfully added to or refreshed in the DataTables.

FillAsync(DataTable[], Int32, Int32, IDbCommand, CommandBehavior, CancellationToken)

Asynchronous version of the Fill(DataTable[], Int32, Int32, IDbCommand, CommandBehavior) method.

Declaration

public Task<int> FillAsync(DataTable[] dataTables, int startRecord, int maxRecords, IDbCommand command, CommandBehavior behavior, CancellationToken cancellationToken)

Parameters

Type	Name	Description
DataTable[]	dataTables	The DataTables to fill with records.
Int32	startRecord	The start record.
Int32	maxRecords	The max number of affected records.
IDbCommand	command	The SQL SELECT statement used to retrieve rows from the data source.
CommandBehavior	behavior	One of the CommandBehavior values.
CancellationToken	cancellationToken	The cancellation token.

Returns

Type	Description
Task<Int32>	The number of rows successfully added to or refreshed in the DataTables.

FillAsync(Int32, Int32, DataTable[])

Asynchronous version of the Fill(Int32, Int32, DataTable[]) method.

Declaration

public Task<int> FillAsync(int startRecord, int maxRecords, params DataTable[] dataTables)

Parameters

Type	Name	Description
Int32	startRecord	The start record.
Int32	maxRecords	The max number of affected records.
DataTable[]	dataTables	The DataTables to fill with records.

Returns

Type	Description
Task<Int32>	The number of rows successfully added to or refreshed in the DataTable.

FillAsync(Int32, Int32, CancellationToken, DataTable[])

Asynchronous version of the Fill(Int32, Int32, DataTable[]) method.

Declaration

public Task<int> FillAsync(int startRecord, int maxRecords, CancellationToken cancellationToken, params DataTable[] dataTables)

Parameters

Type	Name	Description
Int32	startRecord	The start record.
Int32	maxRecords	The max number of affected records.
CancellationToken	cancellationToken	The cancellation token.
DataTable[]	dataTables	The DataTables to fill with records.

Returns

Type	Description
Task<Int32>	The number of rows successfully added to or refreshed in the DataTable.

FillSchemaAsync(DataSet, SchemaType)

Asynchronous version of the FillSchema(DataSet, SchemaType) method.

Declaration

public Task<DataTable[]> FillSchemaAsync(DataSet dataSet, SchemaType schemaType)

Parameters

Type	Name	Description
DataSet	dataSet	DataSet to use.
SchemaType	schemaType	Schema type to use.

Returns

Type	Description
Task<DataTable[]>	DataTable[]

FillSchemaAsync(DataSet, SchemaType, IDbCommand, String, CommandBehavior)

Asynchronous version of the FillSchema(DataSet, SchemaType, IDbCommand, String, CommandBehavior) method.

Declaration

public Task<DataTable[]> FillSchemaAsync(DataSet dataSet, SchemaType schemaType, IDbCommand command, string srcTable, CommandBehavior behavior)

Parameters

Type	Name	Description
DataSet	dataSet	DataSet to use.
SchemaType	schemaType	Schema type to use.
IDbCommand	command	DBCommand to use.
String	srcTable	Source table to use.
CommandBehavior	behavior	Command Behavior

Returns

Type	Description
Task<DataTable[]>	DataTable[]

FillSchemaAsync(DataSet, SchemaType, IDbCommand, String, CommandBehavior, CancellationToken)

Asynchronous version of the FillSchema(DataSet, SchemaType, IDbCommand, String, CommandBehavior) method.

Declaration

public Task<DataTable[]> FillSchemaAsync(DataSet dataSet, SchemaType schemaType, IDbCommand command, string srcTable, CommandBehavior behavior, CancellationToken cancellationToken)

Parameters

Type	Name	Description
DataSet	dataSet	DataSet to use.
SchemaType	schemaType	Schema type to use.
IDbCommand	command	DBCommand to use.
String	srcTable	Source table to use.
CommandBehavior	behavior	Command Behavior
CancellationToken	cancellationToken	CancellationToken to use.

Returns

Type	Description
Task<DataTable[]>	DataTable[]

FillSchemaAsync(DataSet, SchemaType, String)

Asynchronous version of the FillSchema(DataSet, SchemaType, String) method.

Declaration

public Task<DataTable[]> FillSchemaAsync(DataSet dataSet, SchemaType schemaType, string srcTable)

Parameters

Type	Name	Description
DataSet	dataSet	DataSet to use.
SchemaType	schemaType	Schema type to use.
String	srcTable	Source table to use.

Returns

Type	Description
Task<DataTable[]>	DataTable[]

FillSchemaAsync(DataSet, SchemaType, String, IDataReader)

Asynchronous version of the FillSchema(DataSet, SchemaType, String) method.

Declaration

public Task<DataTable[]> FillSchemaAsync(DataSet dataSet, SchemaType schemaType, string srcTable, IDataReader dataReader)

Parameters

Type	Name	Description
DataSet	dataSet	DataSet to use.
SchemaType	schemaType	Schema type to use.
String	srcTable	Source table to use.
IDataReader	dataReader	DataReader to use.

Returns

Type	Description
Task<DataTable[]>	DataTable[]

FillSchemaAsync(DataSet, SchemaType, String, IDataReader, CancellationToken)

Asynchronous version of the FillSchema(DataSet, SchemaType, String) method.

Declaration

public Task<DataTable[]> FillSchemaAsync(DataSet dataSet, SchemaType schemaType, string srcTable, IDataReader dataReader, CancellationToken cancellationToken)

Parameters

Type	Name	Description
DataSet	dataSet	DataSet to use.
SchemaType	schemaType	Schema type to use.
String	srcTable	Source table to use.
IDataReader	dataReader	IDataReader to use.
CancellationToken	cancellationToken	CancellationToken to use.

Returns

Type	Description
Task<DataTable[]>	DataTable[]

FillSchemaAsync(DataSet, SchemaType, String, CancellationToken)

Asynchronous version of the FillSchema(DataSet, SchemaType, String) method.

Declaration

public Task<DataTable[]> FillSchemaAsync(DataSet dataSet, SchemaType schemaType, string srcTable, CancellationToken cancellationToken)

Parameters

Type	Name	Description
DataSet	dataSet	DataSet to use.
SchemaType	schemaType	Schema type to use.
String	srcTable	Source table to use.
CancellationToken	cancellationToken	CancellationToken to use.

Returns

Type	Description
Task<DataTable[]>	DataTable[]

FillSchemaAsync(DataSet, SchemaType, CancellationToken)

Asynchronous version of the FillSchema(DataSet, SchemaType) method.

Declaration

public Task<DataTable[]> FillSchemaAsync(DataSet dataSet, SchemaType schemaType, CancellationToken cancellationToken)

Parameters

Type	Name	Description
DataSet	dataSet	DataSet to use.
SchemaType	schemaType	Schema type to use.
CancellationToken	cancellationToken	CancellationToken to use.

Returns

Type	Description
Task<DataTable[]>	DataTable[]

FillSchemaAsync(DataTable, SchemaType)

Asynchronous version of the FillSchema(DataTable, SchemaType) method.

Declaration

public Task<DataTable> FillSchemaAsync(DataTable dataTable, SchemaType schemaType)

Parameters

Type	Name	Description
DataTable	dataTable	DataTable to use.
SchemaType	schemaType	Schema type to use.

Returns

Type	Description
Task<DataTable>	DataTable

FillSchemaAsync(DataTable, SchemaType, IDataReader)

Asynchronous version of the FillSchema(DataTable, SchemaType) method.

Declaration

public Task<DataTable> FillSchemaAsync(DataTable dataTable, SchemaType schemaType, IDataReader dataReader)

Parameters

Type	Name	Description
DataTable	dataTable	DataTable to use.
SchemaType	schemaType	Schema type to use.
IDataReader	dataReader	DataReader to use.

Returns

Type	Description
Task<DataTable>	DataTable

FillSchemaAsync(DataTable, SchemaType, IDataReader, CancellationToken)

Asynchronous version of the FillSchema(DataTable, SchemaType) method.

Declaration

public Task<DataTable> FillSchemaAsync(DataTable dataTable, SchemaType schemaType, IDataReader dataReader, CancellationToken cancellationToken)

Parameters

Type	Name	Description
DataTable	dataTable	DataTable to use.
SchemaType	schemaType	Schema type to use.
IDataReader	dataReader	DataReader to use.
CancellationToken	cancellationToken	CancellationToken to use.

Returns

Type	Description
Task<DataTable>	DataTable

FillSchemaAsync(DataTable, SchemaType, IDbCommand, CommandBehavior)

Asynchronous version of the FillSchema(DataTable, SchemaType, IDbCommand, CommandBehavior) method.

Declaration

public Task<DataTable> FillSchemaAsync(DataTable dataTable, SchemaType schemaType, IDbCommand command, CommandBehavior behavior)

Parameters

Type	Name	Description
DataTable	dataTable	DataTable to use.
SchemaType	schemaType	Schema type to use.
IDbCommand	command	DBCommand to use.
CommandBehavior	behavior	Command Behavior

Returns

Type	Description
Task<DataTable>	DataTable

FillSchemaAsync(DataTable, SchemaType, IDbCommand, CommandBehavior, CancellationToken)

Asynchronous version of the FillSchema(DataTable, SchemaType, IDbCommand, CommandBehavior) method.

Declaration

public Task<DataTable> FillSchemaAsync(DataTable dataTable, SchemaType schemaType, IDbCommand command, CommandBehavior behavior, CancellationToken cancellationToken)

Parameters

Type	Name	Description
DataTable	dataTable	DataTable to use.
SchemaType	schemaType	Schema type to use.
IDbCommand	command	DBCommand to use.
CommandBehavior	behavior	Command behavior.
CancellationToken	cancellationToken	CancellationToken to use.

Returns

Type	Description
Task<DataTable>	DataTable

FillSchemaAsync(DataTable, SchemaType, CancellationToken)

Asynchronous version of the FillSchema(DataTable, SchemaType) method.

Declaration

public Task<DataTable> FillSchemaAsync(DataTable dataTable, SchemaType schemaType, CancellationToken cancellationToken)

Parameters

Type	Name	Description
DataTable	dataTable	DataTable to use.
SchemaType	schemaType	Schema type to use.
CancellationToken	cancellationToken	CancellationToken to use.

Returns

Type	Description
Task<DataTable>	DataTable

GetBatchedParameter(Int32, Int32)

Returns a System.Data.IDataParameter from one of the commands in the current batch.

Declaration

protected override IDataParameter GetBatchedParameter(int commandIdentifier, int parameterIndex)

Parameters

Type	Name	Description
Int32	commandIdentifier	The index of the command to retrieve the parameter from.
Int32	parameterIndex	The index of the parameter within the command.

Returns

Type	Description
IDataParameter	The IDataParameter specified.

Overrides

DbDataAdapter.GetBatchedParameter(Int32, Int32)

InitializeBatching()

Initializes batching for the MySqlDataAdapter.

Declaration

protected override void InitializeBatching()

Overrides

DbDataAdapter.InitializeBatching()

OnRowUpdated(RowUpdatedEventArgs)

Overridden. Raises the RowUpdated event.

Declaration

protected override void OnRowUpdated(RowUpdatedEventArgs value)

Parameters

Type	Name	Description
RowUpdatedEventArgs	value	A MySqlRowUpdatedEventArgs that contains the event data.

Overrides

DbDataAdapter.OnRowUpdated(RowUpdatedEventArgs)

OnRowUpdating(RowUpdatingEventArgs)

Overridden. Raises the RowUpdating event.

Declaration

protected override void OnRowUpdating(RowUpdatingEventArgs value)

Parameters

Type	Name	Description
RowUpdatingEventArgs	value	A MySqlRowUpdatingEventArgs that contains the event data.

Overrides

DbDataAdapter.OnRowUpdating(RowUpdatingEventArgs)

TerminateBatching()

Ends batching for the MySqlDataAdapter.

Declaration

protected override void TerminateBatching()

Overrides

DbDataAdapter.TerminateBatching()

Update(DataRow[], DataTableMapping)

Declaration

protected override int Update(DataRow[] dataRows, DataTableMapping tableMapping)

Parameters

Type	Name	Description
DataRow[]	dataRows
DataTableMapping	tableMapping

Returns

Type	Description
Int32

Overrides

DbDataAdapter.Update(DataRow[], DataTableMapping)

UpdateAsync(DataRow[])

Asynchronous version of the Update(DataSet) method.

Declaration

public Task<int> UpdateAsync(DataRow[] dataRows)

Parameters

Type	Name	Description
DataRow[]	dataRows	DataRow[] to use.

Returns

Type	Description
Task<Int32>	The number of rows successfully updated from the DataSet.

UpdateAsync(DataRow[], DataTableMapping)

Asynchronous version of the Update(DataSet) method.

Declaration

public Task<int> UpdateAsync(DataRow[] dataRows, DataTableMapping tableMapping)

Parameters

Type	Name	Description
DataRow[]	dataRows	DataRow[] to use.
DataTableMapping	tableMapping	Data Table Mapping

Returns

Type	Description
Task<Int32>	The number of rows successfully updated from the DataSet.

UpdateAsync(DataRow[], DataTableMapping, CancellationToken)

Asynchronous version of the Update(DataSet) method.

Declaration

public Task<int> UpdateAsync(DataRow[] dataRows, DataTableMapping tableMapping, CancellationToken cancellationToken)

Parameters

Type	Name	Description
DataRow[]	dataRows	DataRow[] to use.
DataTableMapping	tableMapping	Data Table Mapping
CancellationToken	cancellationToken	CancellationToken to use.

Returns

Type	Description
Task<Int32>	The number of rows successfully updated from the DataSet.

UpdateAsync(DataRow[], CancellationToken)

Asynchronous version of the Update(DataSet) method.

Declaration

public Task<int> UpdateAsync(DataRow[] dataRows, CancellationToken cancellationToken)

Parameters

Type	Name	Description
DataRow[]	dataRows	DataRow[] to use.
CancellationToken	cancellationToken	CancellationToken to use.

Returns

Type	Description
Task<Int32>	The number of rows successfully updated from the DataSet.

UpdateAsync(DataSet)

Asynchronous version of the Update(DataSet) method.

Declaration

public Task<int> UpdateAsync(DataSet dataSet)

Parameters

Type	Name	Description
DataSet	dataSet	DataSet to use.

Returns

Type	Description
Task<Int32>	The number of rows successfully updated from the DataSet.

UpdateAsync(DataSet, String)

Asynchronous version of the Update(DataSet) method.

Declaration

public Task<int> UpdateAsync(DataSet dataSet, string srcTable)

Parameters

Type	Name	Description
DataSet	dataSet	DataSet to use.
String	srcTable	Source table to use.

Returns

Type	Description
Task<Int32>	The number of rows successfully updated from the DataSet.

UpdateAsync(DataSet, String, CancellationToken)

Asynchronous version of the Update(DataSet) method.

Declaration

public Task<int> UpdateAsync(DataSet dataSet, string srcTable, CancellationToken cancellationToken)

Parameters

Type	Name	Description
DataSet	dataSet	DataSet to use.
String	srcTable	Source table to use.
CancellationToken	cancellationToken	CancellationToken to use.

Returns

Type	Description
Task<Int32>	The number of rows successfully updated from the DataSet.

UpdateAsync(DataSet, CancellationToken)

Asynchronous version of the Update(DataSet) method.

Declaration

public Task<int> UpdateAsync(DataSet dataSet, CancellationToken cancellationToken)

Parameters

Type	Name	Description
DataSet	dataSet	DataSet to use.
CancellationToken	cancellationToken	CancellationToken to use.

Returns

Type	Description
Task<Int32>	The number of rows successfully updated from the DataSet.

UpdateAsync(DataTable)

Asynchronous version of the Update(DataSet) method.

Declaration

public Task<int> UpdateAsync(DataTable dataTable)

Parameters

Type	Name	Description
DataTable	dataTable	DataTable to use.

Returns

Type	Description
Task<Int32>	The number of rows successfully updated from the DataSet.

UpdateAsync(DataTable, CancellationToken)

Asynchronous version of the Update(DataSet) method.

Declaration

public Task<int> UpdateAsync(DataTable dataTable, CancellationToken cancellationToken)

Parameters

Type	Name	Description
DataTable	dataTable	DataTable to use.
CancellationToken	cancellationToken	CancellationToken to use.

Returns

Type	Description
Task<Int32>	The number of rows successfully updated from the DataSet.

Events

RowUpdated

Occurs during Update after a command is executed against the data source. The attempt to update is made, so the event fires.

Declaration

public event MySqlRowUpdatedEventHandler RowUpdated

Event Type

Type	Description
MySqlRowUpdatedEventHandler

RowUpdating

Occurs during Update before a command is executed against the data source. The attempt to update is made, so the event fires.

Declaration

public event MySqlRowUpdatingEventHandler RowUpdating

Event Type

Type	Description
MySqlRowUpdatingEventHandler

Implements

System.ComponentModel.IComponent

System.IDisposable

System.ICloneable

System.Data.IDbDataAdapter

System.Data.IDataAdapter