public async Task Should_delete_staging_queue_when_aborting()
{
var endpointName = "FakeEndpoint";
var sut = new MsmqTarget(new TestLoggingAdapter(), connectionString, schema);
await using var endpointTarget = await sut.PrepareTargetEndpointBatchMigrator(endpointName);
await sut.Abort(endpointName);
await using var connection = new SqlConnection(connectionString);
await connection.OpenAsync();
await using var command = connection.CreateCommand();
command.CommandText = string.Format(@"
SELECT COUNT(*)
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = '{1}' AND TABLE_NAME = '{0}' AND TABLE_CATALOG = '{2}'
", MsmqSqlConstants.TimeoutMigrationStagingTable, schema, databaseName);
var result = await command.ExecuteScalarAsync() as int?;
Assert.That(Convert.ToBoolean(result), Is.False);
}
