Class AdbExecuteNonQueryWorker

A worker that executes a query in an SQL database without returning any result set (i.e. INSERT, UPDATE, DELETE and DML statements). The RecordsAffected property is however set when the query finishes.

Also see SQL Database Access, as well as AdbTableNonQueryWorker and AdbExecuteScalarWorker<TResult>.

Note: This worker does participate in any transaction currently active on the connection.

Inheritance

Object

WorkerParent

WorkerBase

WorkerBase<AdbExecuteNonQueryWorker>

AdbExecuteNonQueryWorker

Implements

IDisposeOnFinished

Inherited Members

WorkerBase<AdbExecuteNonQueryWorker>.AddCompletedCallback(Func<AdbExecuteNonQueryWorker, OutcomeStatus, Task<OutcomeStatus>>)

WorkerBase<AdbExecuteNonQueryWorker>.AddRanCallback(Func<AdbExecuteNonQueryWorker, OutcomeStatus, WorkerParentChildrenState, Task<OutcomeStatus>>)

WorkerBase<AdbExecuteNonQueryWorker>.AddStartingCallback(Func<AdbExecuteNonQueryWorker, Task<ProgressStatus>>)

WorkerBase.AddCompletedCallback(Func<WorkerBase, OutcomeStatus, Task<OutcomeStatus>>)

WorkerBase.AddRanCallback(Func<WorkerBase, OutcomeStatus, WorkerParentChildrenState, Task<OutcomeStatus>>)

WorkerBase.AddStartingCallback(Func<WorkerBase, Task<ProgressStatus>>)

WorkerBase.DefaultIsStartable()

WorkerBase.ErroredPortErrorsWorkerProtected

WorkerBase.ErrorOutputs

WorkerBase.EscalateError

WorkerBase.Inputs

WorkerBase.IsStartable

WorkerBase.Outputs

WorkerBase.Parent

WorkerBase.SucceededSequence<TLastWorker>(WorkerBase, WorkerBase, WorkerBase, WorkerBase, WorkerBase, TLastWorker)

WorkerBase.SucceededSequence<TLastWorker>(WorkerBase, WorkerBase, WorkerBase, WorkerBase, TLastWorker)

WorkerBase.SucceededSequence<TLastWorker>(WorkerBase, WorkerBase, WorkerBase, TLastWorker)

WorkerBase.SucceededSequence<TLastWorker>(WorkerBase, WorkerBase, TLastWorker)

WorkerBase.SucceededSequence<TLastWorker>(WorkerBase, TLastWorker)

WorkerBase.SucceededSequence<TLastWorker>(TLastWorker)

WorkerParent.AddChildCompletedCallback(Action<WorkerBase>)

WorkerParent.AddStartingChildrenCallback(Func<WorkerParent, Task<ProgressStatus>>)

WorkerParent.Children

WorkerParent.DisposeOnFinished<TDisposable>(TDisposable)

WorkerParent.GetDownstreamFactory<TInput>()

WorkerParent.HasChildren

WorkerParent.IsCanceled

WorkerParent.IsCompleted

WorkerParent.IsCreated

WorkerParent.IsError

WorkerParent.IsFailed

WorkerParent.IsFatal

WorkerParent.IsRunning

WorkerParent.IsSucceeded

WorkerParent.KeepChildrenLevels

WorkerParent.Locator

WorkerParent.LogFactory

WorkerParent.Logger

WorkerParent.MaxRunningChildren

WorkerParent.Name

WorkerParent.RemoveChildren()

WorkerParent.RescheduleChildren()

WorkerParent.RunChildrenAsync(Boolean)

WorkerParent.RunChildrenAsync()

WorkerParent.Status

WorkerParent.Item[String]

WorkerParent.ToString()

WorkerParent.WorkerSystem

WorkerParent.DebugCommands

WorkerParent.AggregateErrorOutputRows

WorkerParent.AggregateOutputRows

WorkerParent.AggregateWorkersCompleted

WorkerParent.InstantCompleted

WorkerParent.InstantCreated

WorkerParent.InstantStarted

WorkerParent.RunningDuration

Namespace: actionETL.Adb

Assembly: actionETL.dll

Syntax

public class AdbExecuteNonQueryWorker : WorkerBase<AdbExecuteNonQueryWorker>, IDisposeOnFinished

Constructors

AdbExecuteNonQueryWorker(WorkerParent, String, AdbCommandBuilder)

Initializes a new instance of the AdbExecuteNonQueryWorker worker. It executes a query in an SQL database without returning any result set (i.e. INSERT, UPDATE, DELETE and DML statements).

Declaration

public AdbExecuteNonQueryWorker(WorkerParent workerParent, string workerName, AdbCommandBuilder commandBuilder)

Parameters

Type	Name	Description
WorkerParent	workerParent	The parent worker or worker system that the new child worker will be added to. Cannot be null.
String	workerName	Name of the worker. Set to a prefix plus a trailing "/" (e.g. "MyPrefix-/") to generate a unique name from the prefix plus an increasing number starting at 1. While less useful, set to null, whitespace or "/" to generate a unique name from the worker type plus an increasing number starting at 1. The name cannot otherwise contain "/", and cannot start with double underscore "__".
AdbCommandBuilder	commandBuilder	A builder for the database command. Can be null, in which case CommandBuilder must be set before the worker starts running.

Exceptions

Type	Condition
ArgumentException	workerName: Workers with the same parent must have unique names. Worker and worker system names cannot contain '/' or start with double underscore '__'.
ArgumentNullException	workerParent - All workers must have a parent. The top level workers have the worker system as parent.
InvalidOperationException	Cannot add child worker to parent which has completed. Are you adding it to the correct parent? Cannot add worker to parent, since its children have been started. Are you adding it to the correct parent?

AdbExecuteNonQueryWorker(WorkerParent, String, IAdbConnectionBuilder, String)

Initializes a new instance of the AdbExecuteNonQueryWorker worker. It executes a query in an SQL database without returning any result set SQL database without returning any result set (i.e. INSERT, UPDATE, DELETE and DML statements).

Declaration

public AdbExecuteNonQueryWorker(WorkerParent workerParent, string workerName, IAdbConnectionBuilder connectionBuilder, string queryText)

Parameters

Type	Name	Description
WorkerParent	workerParent	The parent worker or worker system that the new child worker will be added to. Cannot be null.
String	workerName	Name of the worker. Set to a prefix plus a trailing "/" (e.g. "MyPrefix-/") to generate a unique name from the prefix plus an increasing number starting at 1. While less useful, set to null, whitespace or "/" to generate a unique name from the worker type plus an increasing number starting at 1. The name cannot otherwise contain "/", and cannot start with double underscore "__".
IAdbConnectionBuilder	connectionBuilder	The connection builder, must not be null.
String	queryText	The query text, must not be null.

Exceptions

Type	Condition
ArgumentNullException	connectionBuilder or queryText must not be null.
ArgumentException	workerName: Workers with the same parent must have unique names. Worker and worker system names cannot contain '/' or start with double underscore '__'.
ArgumentNullException	workerParent - All workers must have a parent. The top level workers have the worker system as parent.
InvalidOperationException	Cannot add child worker to parent which has completed. Are you adding it to the correct parent? Cannot add worker to parent, since its children have been started. Are you adding it to the correct parent?

AdbExecuteNonQueryWorker(WorkerParent, String, IAdbConnectionBuilder, String, CommandType)

Initializes a new instance of the AdbExecuteNonQueryWorker worker. It executes a query in an SQL database without returning any result set (i.e. INSERT, UPDATE, DELETE and DML statements).

Declaration

public AdbExecuteNonQueryWorker(WorkerParent workerParent, string workerName, IAdbConnectionBuilder connectionBuilder, string queryText, CommandType commandType)

Parameters

Type	Name	Description
WorkerParent	workerParent	The parent worker or worker system that the new child worker will be added to. Cannot be null.
String	workerName	Name of the worker. Set to a prefix plus a trailing "/" (e.g. "MyPrefix-/") to generate a unique name from the prefix plus an increasing number starting at 1. While less useful, set to null, whitespace or "/" to generate a unique name from the worker type plus an increasing number starting at 1. The name cannot otherwise contain "/", and cannot start with double underscore "__".
IAdbConnectionBuilder	connectionBuilder	The connection builder, must not be null.
String	queryText	The query text, must not be null.
CommandType	commandType	Type of the command.

Exceptions

Type	Condition
ArgumentNullException	connectionBuilder or queryText must not be null.
ArgumentException	workerName: Workers with the same parent must have unique names. Worker and worker system names cannot contain '/' or start with double underscore '__'.
ArgumentNullException	workerParent - All workers must have a parent. The top level workers have the worker system as parent.
InvalidOperationException	Cannot add child worker to parent which has completed. Are you adding it to the correct parent? Cannot add worker to parent, since its children have been started. Are you adding it to the correct parent?

AdbExecuteNonQueryWorker(WorkerParent, String, Func<Boolean>, AdbCommandBuilder)

Initializes a new instance of the AdbExecuteNonQueryWorker worker. It executes a query in an SQL database without returning any result set (i.e. INSERT, UPDATE, DELETE and DML statements).

Declaration

public AdbExecuteNonQueryWorker(WorkerParent workerParent, string workerName, Func<bool> isStartableFunc, AdbCommandBuilder commandBuilder)

Parameters

Type	Name	Description
WorkerParent	workerParent	The parent worker or worker system that the new child worker will be added to. Cannot be null.
String	workerName	Name of the worker. Set to a prefix plus a trailing "/" (e.g. "MyPrefix-/") to generate a unique name from the prefix plus an increasing number starting at 1. While less useful, set to null, whitespace or "/" to generate a unique name from the worker type plus an increasing number starting at 1. The name cannot otherwise contain "/", and cannot start with double underscore "__".
Func<Boolean>	isStartableFunc	Function to calculate the worker start constraint; it should return true for startable and false for not startable. Defaults to startable if null.
AdbCommandBuilder	commandBuilder	A builder for the database command. Can be null, in which case CommandBuilder must be set before the worker starts running.

Exceptions

Type	Condition
ArgumentException	workerName: Workers with the same parent must have unique names. Worker and worker system names cannot contain '/' or start with double underscore '__'.
ArgumentNullException	workerParent - All workers must have a parent. The top level workers have the worker system as parent.
InvalidOperationException	Cannot add child worker to parent which has completed. Are you adding it to the correct parent? Cannot add worker to parent, since its children have been started. Are you adding it to the correct parent?

AdbExecuteNonQueryWorker(WorkerParent, String, Func<Boolean>, IAdbConnectionBuilder, String)

Initializes a new instance of the AdbExecuteNonQueryWorker worker. It executes a query in an SQL database without returning any result set SQL database without returning any result set (i.e. INSERT, UPDATE, DELETE and DML statements).

Declaration

public AdbExecuteNonQueryWorker(WorkerParent workerParent, string workerName, Func<bool> isStartableFunc, IAdbConnectionBuilder connectionBuilder, string queryText)

Parameters

Type	Name	Description
WorkerParent	workerParent	The parent worker or worker system that the new child worker will be added to. Cannot be null.
String	workerName	Name of the worker. Set to a prefix plus a trailing "/" (e.g. "MyPrefix-/") to generate a unique name from the prefix plus an increasing number starting at 1. While less useful, set to null, whitespace or "/" to generate a unique name from the worker type plus an increasing number starting at 1. The name cannot otherwise contain "/", and cannot start with double underscore "__".
Func<Boolean>	isStartableFunc	Function to calculate the worker start constraint; it should return true for startable and false for not startable. Defaults to startable if null.
IAdbConnectionBuilder	connectionBuilder	The connection builder, must not be null.
String	queryText	The query text, must not be null.

Exceptions

Type	Condition
ArgumentNullException	connectionBuilder or queryText must not be null.
ArgumentException	workerName: Workers with the same parent must have unique names. Worker and worker system names cannot contain '/' or start with double underscore '__'.
ArgumentNullException	workerParent - All workers must have a parent. The top level workers have the worker system as parent.
InvalidOperationException	Cannot add child worker to parent which has completed. Are you adding it to the correct parent? Cannot add worker to parent, since its children have been started. Are you adding it to the correct parent?

AdbExecuteNonQueryWorker(WorkerParent, String, Func<Boolean>, IAdbConnectionBuilder, String, CommandType)

Initializes a new instance of the AdbExecuteNonQueryWorker worker. It executes a query in an SQL database without returning any result set (i.e. INSERT, UPDATE, DELETE and DML statements).

Declaration

public AdbExecuteNonQueryWorker(WorkerParent workerParent, string workerName, Func<bool> isStartableFunc, IAdbConnectionBuilder connectionBuilder, string queryText, CommandType commandType)

Parameters

Type	Name	Description
WorkerParent	workerParent	The parent worker or worker system that the new child worker will be added to. Cannot be null.
String	workerName	Name of the worker. Set to a prefix plus a trailing "/" (e.g. "MyPrefix-/") to generate a unique name from the prefix plus an increasing number starting at 1. While less useful, set to null, whitespace or "/" to generate a unique name from the worker type plus an increasing number starting at 1. The name cannot otherwise contain "/", and cannot start with double underscore "__".
Func<Boolean>	isStartableFunc	Function to calculate the worker start constraint; it should return true for startable and false for not startable. Defaults to startable if null.
IAdbConnectionBuilder	connectionBuilder	The connection builder, must not be null.
String	queryText	The query text, must not be null.
CommandType	commandType	Type of the command.

Exceptions

Type	Condition
ArgumentNullException	connectionBuilder or queryText must not be null.
ArgumentException	workerName: Workers with the same parent must have unique names. Worker and worker system names cannot contain '/' or start with double underscore '__'.
ArgumentNullException	workerParent - All workers must have a parent. The top level workers have the worker system as parent.
InvalidOperationException	Cannot add child worker to parent which has completed. Are you adding it to the correct parent? Cannot add worker to parent, since its children have been started. Are you adding it to the correct parent?

Properties

CommandBuilder

Gets or sets the builder for the database command. Can only be set before the worker starts running.

Note: This property is thread-safe.

Declaration

public AdbCommandBuilder CommandBuilder { get; set; }

Property Value

Type	Description
AdbCommandBuilder

Exceptions

Type	Condition
InvalidOperationException	Cannot set the value after the worker has started running.

RecordsAffected

Gets the number of records affected by an UPDATE, INSERT, or DELETE query. For all other types of statements, the return value is -1. Only available after the worker has completed successfully.

Note: This property is thread-safe.

Declaration

public int RecordsAffected { get; }

Property Value

Type	Description
Int32

Exceptions

Type	Condition
InvalidOperationException	Value only available after the worker has completed successfully. Value not set.

Methods

RunAsync()

This method can be overridden to add custom functionality to the derived worker that runs before and after the row processing. In this case, the base class base.RunAsync() must be called for the worker to function correctly.

Typically, this worker is used without overriding this method.

Declaration

protected override async Task<OutcomeStatus> RunAsync()

Returns

Type	Description
Task<OutcomeStatus>	A Task describing the success or failure of the worker. An asynchronous async implementation would e.g. return OutcomeStatus.Succeeded on success, while a synchronous implementation would return OutcomeStatus.SucceededTask.

Overrides

WorkerParent.RunAsync()

Implements

IDisposeOnFinished

See Also

AdbTableNonQueryWorker

AdbExecuteScalarWorker<TResult>