c# - 如果在 SQL 中启用了 Broker Service，我如何检查 c#？

Question

我想使用代码检查 Broker Service 是否正在运行，并根据状态启动 sqldependency 或不启动。我该怎么做？

Answer 1

你可以做一个简单的查询:

SELECT is_broker_enabled FROM sys.databases WHERE Name = 'mydatabasename'

或者，您可以只启动 SqlDependency 并捕获您收到的错误(如果它尚未启用)，但第一种方法更简单且更好:

  try {
      SqlDependency.Start();
  } catch (InvalidOperationException ex) {
      // If broker hasn't been enabled, you'll get the following exception:
      //
      // The SQL Server Service Broker for the current database is not enabled, and
      // as a result query notifications are not supported.  Please enable the Service
      // Broker for this database if you wish to use notifications.
  }