コード例 #1
0
        public static async Task DeleteSharedQueues()
        {
            var connectionString = @"Data Source=.\SqlExpress;Database=samples;Integrated Security=True";

            #region sqlserver-delete-queues-shared-usage

            using (var sqlConnection = new SqlConnection(connectionString))
            {
                await sqlConnection.OpenAsync()
                .ConfigureAwait(false);

                await QueueDeletionUtils.DeleteQueue(
                    connection : sqlConnection,
                    schema : "dbo",
                    queueName : "audit")
                .ConfigureAwait(false);

                await QueueDeletionUtils.DeleteQueue(
                    connection : sqlConnection,
                    schema : "dbo",
                    queueName : "error")
                .ConfigureAwait(false);
            }

            #endregion
        }
コード例 #2
0
        public void DeleteSharedQueues()
        {
            var connectionString = @"Data Source=.\SqlExpress;Database=samples;Integrated Security=True";

            using (var sqlConnection = new SqlConnection(connectionString))
            {
                sqlConnection.Open();
                QueueDeletionUtils.DeleteQueue(
                    connection: sqlConnection,
                    schema: "dbo",
                    queueName: "audit");
                QueueDeletionUtils.DeleteQueue(
                    connection: sqlConnection,
                    schema: "dbo",
                    queueName: "error");
            }
        }
コード例 #3
0
        public static async Task DeleteQueuesForEndpoint(SqlConnection connection, string schema, string endpointName)
        {
            // main queue
            await QueueDeletionUtils.DeleteQueue(connection, schema, endpointName)
            .ConfigureAwait(false);

            // callback queue
            await QueueDeletionUtils.DeleteQueue(connection, schema, $"{endpointName}.{Environment.MachineName}")
            .ConfigureAwait(false);

            // timeout queue
            await QueueDeletionUtils.DeleteQueue(connection, schema, $"{endpointName}.Timeouts")
            .ConfigureAwait(false);

            // timeout dispatcher queue
            await QueueDeletionUtils.DeleteQueue(connection, schema, $"{endpointName}.TimeoutsDispatcher")
            .ConfigureAwait(false);
        }
コード例 #4
0
        public static void DeleteQueuesForEndpoint(SqlConnection connection, string schema, string endpointName)
        {
            // main queue
            QueueDeletionUtils.DeleteQueue(connection, schema, endpointName);

            // callback queue
            QueueDeletionUtils.DeleteQueue(connection, schema, $"{endpointName}.{Environment.MachineName}");

            // timeout queue
            QueueDeletionUtils.DeleteQueue(connection, schema, $"{endpointName}.Timeouts");

            // timeout dispatcher queue
            QueueDeletionUtils.DeleteQueue(connection, schema, $"{endpointName}.TimeoutsDispatcher");

            // retries queue
            // TODO: Only required in Versions 2 and below
            QueueDeletionUtils.DeleteQueue(connection, schema, $"{endpointName}.Retries");
        }
コード例 #5
0
        public static void DeleteSharedQueues()
        {
            var connectionString = @"Data Source=.\SqlExpress;Database=samples;Integrated Security=True";

            #region sqlserver-delete-queues-shared-usage

            using (var connection = new SqlConnection(connectionString))
            {
                connection.Open();
                QueueDeletionUtils.DeleteQueue(
                    connection: connection,
                    schema: "dbo",
                    queueName: "audit");
                QueueDeletionUtils.DeleteQueue(
                    connection: connection,
                    schema: "dbo",
                    queueName: "error");
            }

            #endregion
        }