Class MsAccessBulkUpdate

Class for fast bulk data update for Microsoft Access.

Inheritance
System.Object
BulkUpdateBase
MsAccessBulkUpdate
Implements
Inherited Members
Namespace: Kros.Data.BulkActions.MsAccess
Assembly: Kros.Utils.MsAccess.dll
Syntax
public class MsAccessBulkUpdate : BulkUpdateBase, IBulkUpdate, IDisposable
Remarks

The bulk update uses a temporary database.

Examples

Constructors

MsAccessBulkUpdate(OleDbConnection)

Creates new instance of MsAccessBulkUpdate for database connection.

Declaration
public MsAccessBulkUpdate(OleDbConnection connection)
Parameters
Type Name Description
System.Data.OleDb.OleDbConnection connection

Database connection where the data will be inserted. The connection mus be opened.

MsAccessBulkUpdate(OleDbConnection, OleDbTransaction)

Creates new instance of MsAccessBulkUpdate for database connection and with transaction externalTransaction.

Declaration
public MsAccessBulkUpdate(OleDbConnection connection, OleDbTransaction externalTransaction)
Parameters
Type Name Description
System.Data.OleDb.OleDbConnection connection

Database connection where the data will be inserted. The connection mus be opened. If there already is running transaction in this connection, it must be specified in externalTransaction.
System.Data.OleDb.OleDbTransaction externalTransaction

Transaction in which the bulk insert will be performed.

MsAccessBulkUpdate(String)

Creates new instance of MsAccessBulkUpdate for database connectionString.

Declaration
public MsAccessBulkUpdate(string connectionString)
Parameters
Type Name Description
System.String connectionString

Connection string to the database where the data will be inserted.

Methods

CreateBulkInsert()

Declaration
protected override IBulkInsert CreateBulkInsert()
Returns
Type Description
IBulkInsert
Overrides

CreateCommandForPrimaryKey()

Declaration
protected override IDbCommand CreateCommandForPrimaryKey()
Returns
Type Description
System.Data.IDbCommand
Overrides

CreateTempTable(IDataReader, String)

Declaration
protected override void CreateTempTable(IDataReader reader, string tempTableName)
Parameters
Type Name Description
System.Data.IDataReader reader
System.String tempTableName
Overrides

Dispose(Boolean)

Declaration
protected override void Dispose(bool disposing)
Parameters
Type Name Description
System.Boolean disposing
Overrides

GetTempTableName()

Declaration
protected override string GetTempTableName()
Returns
Type Description
System.String
Overrides

GetTempTableNameForBulkInsert(String)

Declaration
protected override string GetTempTableNameForBulkInsert(string name)
Parameters
Type Name Description
System.String name
Returns
Type Description
System.String
Overrides

InvokeAction(String)

Declaration
protected override void InvokeAction(string tempTableName)
Parameters
Type Name Description
System.String tempTableName
Overrides

UpdateDestinationTableAsync(IDataReader, String, Boolean)

Declaration
protected override Task UpdateDestinationTableAsync(IDataReader reader, string tempTableName, bool useAsync)
Parameters
Type Name Description
System.Data.IDataReader reader
System.String tempTableName
System.Boolean useAsync
Returns
Type Description
System.Threading.Tasks.Task
Overrides

Implements