Class AdbSqlClientTableCommandService

For a SQL Server® Microsoft.Data.SqlClient 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, AdbSqlClientTableInformationService, AdbSqlClientDataSourceInformationService, AdbConnection and AdbProvider.

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

Methods

DropTableAsync(String, Boolean)

Drop a table.

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

Declaration
public override async Task<OutcomeStatus> DropTableAsync(string compositeTableName, bool ifExists)
Parameters
Type Name Description
String compositeTableName

Table to drop. Can be a composite name.
Boolean ifExists

If true, only drop the table if it exists. If false, always drop the table, which will fail if it doesn't exist.
Returns
Type Description
Task<OutcomeStatus>

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

Get()

Gets a function that returns a new instance of AdbSqlClientTableCommandService on each invocation, which is used when instantiating a new AdbProvider for accessing a SQL Server® data source.

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

Implements

See Also