public void DeleteAll(string applicationName, IDbTransaction transaction)
{
const string Sql =
@"DELETE FROM [BlueCollarHistory] WHERE [ApplicationName] = @ApplicationName;
DELETE FROM [BlueCollarWorking] WHERE [ApplicationName] = @ApplicationName;
DELETE FROM [BlueCollarWorker] WHERE [ApplicationName] = @ApplicationName;
DELETE FROM [BlueCollarQueue] WHERE [ApplicationName] = @ApplicationName;
DELETE FROM [BlueCollarScheduledJob]
WHERE
[ScheduleId] IN
(
SELECT [Id]
FROM [BlueCollarSchedule]
WHERE
[ApplicationName] = @ApplicationName
);
DELETE FROM [BlueCollarSchedule] WHERE [ApplicationName] = @ApplicationName;";
this.connection.Execute(
Sql,
new { ApplicationName = applicationName },
transaction,
null,
null);
}