The IBatcher type exposes the following members.

Methods

  NameDescription
Public methodAbortBatch
Must be called when an exception occurs.
Public methodAddToBatch
Add an insert / delete / update to the current batch (might be called multiple times for a single PrepareBatchStatement())
Public methodCancelLastQuery
Cancel the current query statement
Public methodCloseCommand
Close a IDbCommand opened using PrepareCommand()
Public methodCloseCommands
Close any query statements that were left lying around
Public methodCloseReader
Public methodDispose
Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
(Inherited from IDisposable.)
Public methodExecuteBatch
Execute the batch
Public methodExecuteNonQuery
Executes the IDbCommand.
Public methodExecuteReader
Gets an IDataReader by calling ExecuteReader on the IDbCommand.
Public methodExpandQueryParameters
Expand the parameters of the cmd to have a single parameter for each parameter in the sql string
Public methodPrepareBatchCommand
Get a batchable IDbCommand to use for inserting / deleting / updating (might be called many times before a single call to ExecuteBatch()
Public methodPrepareCommand
Get a non-batchable an IDbCommand to use for inserting / deleting / updating. Must be explicitly released by CloseCommand()
Public methodPrepareQueryCommand
Get an IDbCommand for using in loading / querying.
Public methodRemoveUnusedCommandParameters

Properties

  NameDescription
Public propertyBatchSize
Gets or sets the size of the batch, this can change dynamically by calling the session's SetBatchSize.
Public propertyHasOpenResources
Gets the value indicating whether there are any open resources managed by this batcher (IDbCommands or IDataReaders).

See Also