BlueCollar.SQLiteRepository.DeleteAll C# (CSharp) Метод

DeleteAll() публичный Метод

Deletes all data in the repository.
public DeleteAll ( string applicationName, IDbTransaction transaction ) : void
applicationName string The name of the application to delete data for.
transaction IDbTransaction The transaction to use, if applicable.
Результат void
        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);
        }