public void Setup()
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
QueueDeletion.DeleteQueuesForEndpoint(connection, schema, endpointName);
QueueDeletion.DeleteQueuesForEndpoint(connection, schema, errorQueueName);
}
}
public void DeleteQueuesForEndpoint()
{
string connectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog=samples;Integrated Security=True";
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.Open();
QueueDeletion.DeleteQueuesForEndpoint(
connection: sqlConnection,
schema: "dbo",
endpointName: "myendpoint");
}
}
public void DeleteQueuesForEndpoint()
{
string databaseName = "myDatabase";
string connectionString = string.Format(@"Data Source=.\SQLEXPRESS;Initial Catalog={0};Integrated Security=True", databaseName);
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.Open();
QueueDeletion.DeleteQueuesForEndpoint(
connection: sqlConnection,
schema: "dbo",
endpointName: "myendpoint");
}
}
public void DeleteSharedQueues()
{
string connectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog=samples;Integrated Security=True";
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.Open();
QueueDeletion.DeleteQueue(
connection: sqlConnection,
schema: "dbo",
queueName: "audit");
QueueDeletion.DeleteQueue(
connection: sqlConnection,
schema: "dbo",
queueName: "error");
}
}