Namespace ETLBox.ControlFlow.Tasks

Classes

CleanUpSchemaTask

Tries to remove all database objects from the given schema(s). Currently only SqlServer and Oracle support this task.

CreateDatabaseTask

Will create a database if the database doesn't exists. In MySql or MariaDb, this will create a schema.

CreateIndexTask

Creates an index if the index doesn't exists, otherwise the index is dropped and recreated.

CreateProcedureTask

Creates or updates a procedure.

CreateSchemaTask

Creates a schema. For MySql or MariaDb, use the CreateDatabaseTask instead. The Create method will throw an exception if the schema already exists. CreateIfNotExists will only create a schema if it doesn't exists.

CreateTableTask

Creates a table. If the tables exists, this task won't change the table.

CreateViewTask

Creates or alters a view.

DropDatabaseTask

Drops a database. Use DropIfExists to drop a database only if it exists. In MySql, this will drop a schema.

DropIndexTask

Drops an index. Use DropIfExists to drop an index only if it exists.

DropProcedureTask

Drops a procedure. Use DropIfExists to drop a procedure only if it exists.

DropSchemaTask

Drops a schema. Use DropIfExists to drop a schema only if it exists. For MySql or MariaDb, use the DropDatabase task instead.

DropTableTask

Drops a table. Use DropIfExists to drop a table only if it exists.

DropViewTask

Drops a view. Use DropIfExists to drop a view only if it exists.

GetDatabaseListTask

Returns a list of all user databases on the server. Make sure to connect with the correct permissions! In MySql, this will return a list of all schemas.

GetListTask

Returns a list of all user databases on the server. Make sure to connect with the correct permissions! In MySql, this will return a list of all schemas.

GetTableListTask

Returns a list of all tables in the currently connected database.
Make sure to connect with the correct permissions!

GetViewListTask

Returns a list of all tables in the currently connected database.
Make sure to connect with the correct permissions!

IfDatabaseExistsTask

Checks if a database exists.

IfIndexExistsTask

Checks if an index exists.

IfProcedureExistsTask

Checks if a procedure exists.

IfSchemaExistsTask

Checks if a schema exists. In MySql or MariaDb, use the IfDatabaseExistsTask instead.

IfTableOrViewExistsTask

Checks if a table exists.

RowCountTask

Count the row in a table. This task normally uses the COUNT(*) method (could take some time on big tables). You can pass a a filter condition for the count.

SqlTask

Executes any sql on the database. Use ExecuteNonQuery for SQL statements returning no data, ExecuteScalar for statements that return only one row and one column or ExecuteReader for SQL that returns multiple rows or columns

TruncateTableTask

Truncates a table.

XmlaTask

This task can exeucte any XMLA.

Enums

RecoveryModel

The sql server recovery models.

RowCountOptions

Used in the RowCountTask. None forces the RowCountTask to do a normal COUNT() and works on all databases. QuickQueryMode only works on SqlServer and uses the partition table which can be much faster on tables with a big amount of data. DirtyRead does a normal COUNT() but also reading uncommitted reads.