Search Results for

    Show / Hide Table of Contents

    Non-Dataflow Workers

    A non-dataflow (a.k.a. control flow) worker has no input or output ports.

    Also see the dataflow workers:

    • Source Workers
    • Transform Workers
    • Target Workers
    Note

    There is no fundamental difference between dataflow and non-dataflow workers; they can be mixed and matched as needed.

    ActionWorker

    Run an Action or Func callback, optionally creating child workers.

    • Worker: ActionWorker
    • Examples:
      • Adding and Grouping Workers
      • Data Formats
      • Transfer Protocols
      • Worker Execution

    ActionWorkerBase

    Run an Action or Func callback, optionally creating child workers. Must be inherited.

    • Worker: ActionWorkerBase<TDerived>
    • Example: Custom Workers

    AdbExecuteNonQueryWorker

    Execute a query on an SQL database (e.g. INSERT, UPDATE, DELETE and DML statements) without returning any result set. RecordsAffected is returned.

    • Worker: AdbExecuteNonQueryWorker
    • Examples:
      • Adb Commands and Parameters
      • Adb Keep Open Connection
      • Slowly Changing Dimension Example

    AdbExecuteScalarWorker

    Execute a query on an SQL database and return a single result value.

    • Worker: AdbExecuteScalarWorker<TResult>
    • Examples for the similar AdbExecuteNonQueryWorker:
      • Adb Commands and Parameters
      • Adb Keep Open Connection
      • Slowly Changing Dimension Example

    AdbTableNonQueryWorker

    Generate and execute a provider-specific query on a table-like object in an SQL database: DELETE all rows (with RecordsAffected), IF EXISTS, DROP, or TRUNCATE.

    • Worker: AdbTableNonQueryWorker
    • Examples:
      • SQL Database Access
      • Samples

    AdbTransactionActionWorker

    Creates an AdbKeepOpenConnection and a local AdbTransaction, runs a user supplied callback inside the transaction, and commits/rolls back and disposes the transaction and connection. The callback typically creates Adb child database workers that automatically participates in the transaction, which will be rolled back if any of these child workers (or the callback) fails.

    • Worker: AdbTransactionActionWorker
    • Example: Adb Keep Open Connection

    CopyFileWorker

    Copy a file.

    • Worker: CopyFileWorker
    • Examples:
      • Worker Error Handling
      • CopyFileIfExists Sample

    CreateFileWorker

    Create a file.

    • Worker: CreateFileWorker
    • Examples for the similar CopyFileWorker:
      • Worker Error Handling
      • CopyFileIfExists Sample

    DeleteFileWorker

    Delete a file.

    • Worker: DeleteFileWorker
    • Examples for the similar CopyFileWorker:
      • Worker Error Handling
      • CopyFileIfExists Sample

    ExecuteProcessWorker

    Launch an external process, e.g. an executable, a batch script, or a document.

    • Worker: ExecuteProcessWorker
    • Examples:
      • actionETL Overview

    FileExistsWorker

    Check if a file exists.

    • Worker: FileExistsWorker
    • Examples:
      • Getting Started
      • Samples

    ForEachActionWorker

    Execute an Action or Func callback once (optionally creating child workers) for each item in an enumerable.

    • Worker: ForEachActionWorker<TItem>
    • Example for the similar WhileActionWorker: Worker Error Handling

    MoveFileWorker

    Move a file.

    • Worker: MoveFileWorker
    • Example: actionETL Overview

    UsingActionWorker

    Mimics the using statement in C#/VB to create an arbitrary disposable object, run a callback with the disposable object, and automatically dispose the object.

    • Worker: UsingActionWorker<TDisposable>
    • Examples:
      • Disposing Disposables
      • Adb Keep Open Connection

    WhileActionWorker

    Execute an Action or Func callback (optionally creating child workers) for each iteration in a while-loop.

    • Worker: WhileActionWorker<T>
    • Example: Worker Error Handling

    Worker

    Bare-bones worker with only the intrinsic functionality inherited from WorkerBase<TDerived> and WorkerBase, such as start constraints and grouping children.

    • Worker: Worker

    WorkerBase and WorkerBase<TDerived>

    WorkerBase is a base class that all other workers inherit from indirectly, via WorkerBase<TDerived>.

    Specify WorkerBase when referring to workers without knowing the final derived worker type. It has many useful members, such as the worker Name, Parent, etc.

    WorkerBase<TDerived> is a base class that all other workers inherit from directly or indirectly. It contains members that use the type of the final derived worker (TDerived).

    • Workers:
      • WorkerBase
      • WorkerBase<TDerived>
    • Examples:
      • Custom Workers
      • Process Incoming Files Example
      • Slowly Changing Dimension Example
      • Custom Adb Development

    See Also

    • Common Tasks
    • Getting Started
    • Worker System
    • Workers
    • Dataflow
      • Source Workers
      • Transform Workers
      • Target Workers
    • SQL Database Access
    • Data Formats
    • Transfer Protocols
    In This Article
    Back to top Copyright © 2021 Envobi Ltd