ExecuteAdhoc

ExecuteAdhoc Method

Used to execute any sql statement for the setup, teardown or test action.

ExecuteAdhoc(string sql)

• sql: is any string of SQL to be executed on the target database. This can be used

Exceptions

• Exception: All exceptions are rethrown giving the context of the method that was called and the sql statement. Note that an error in SQL syntax will cause a test to fail without any additional special handling.

Example

SqlTestTarget dataWarehouseDb = new SqlTestTarget("DataWarehouse");
dataWarehouseDb.ExecuteAdhoc($"Exec proc;");