Namespace ETLBox.ControlFlow.Tasks
Classes
CalculateDatabaseHashTask
Calculates a hash value of the database. It will use only the schemas given in the property SchemaName for the calculation. The hash calcualtion is based only on the user tables in the schema.
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 if the schema doesn't exists. For MySql or MariaDb, use the CreateDatabaseTask instead.
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.
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. NoLock does a normal COUNT() using the nolock - option which avoid tables locks when reading from the table (but while counting the tables new data could be inserted, which could lead to wrong results).