Class AdbSQLiteTableCommandService

For a SQLite data source, implements an optional service that executes predefined table commands (truncate, drop, delete all rows). This class is normally not used directly by the user, but instead via TableCommand. You can however derive from this class (or from a base or descendant class) to customize the information for either the same .NET provider, or for a different but similar .NET provider.

Also see HasTableCommandService, AdbSQLiteTableInformationService, AdbSQLiteDataSourceInformationService, AdbConnection and AdbProvider.

Inheritance
Object
AdbTableCommandServiceBase
AdbSQLiteTableCommandService
Implements
Inherited Members
Namespace: actionETL.Adb.SQLiteExternal
Assembly: actionETL.dll
Syntax
public class AdbSQLiteTableCommandService : AdbTableCommandServiceBase, IAdbTableCommandService

Methods

Get()

Gets a function that returns a new instance of AdbSQLiteTableCommandService on each invocation, which is used when instantiating a new AdbProvider for accessing a SQLite data source.

Declaration
public static Func<IAdbConnection, IAdbTableCommandService> Get()
Returns
Type Description
Func<IAdbConnection, IAdbTableCommandService>

TruncateTableAsync(String)

Truncates a table, using the SQL text: DELETE FROM MyCompositeTableName.

Note that this method does not log errors. Instead the caller should normally log any returned failure status.

Declaration
public override async Task<OutcomeStatus> TruncateTableAsync(string compositeTableName)
Parameters
Type Name Description
String compositeTableName

Table to truncate. Can be a composite name.
Returns
Type Description
Task<OutcomeStatus>

An OutcomeStatus, with Succeeded on success; otherwise one of the failure states.
Overrides

Implements

See Also