# signalr_service_broker

**Repository Path**: zgh_1/signalr_service_broker

## Basic Information

- **Project Name**: signalr_service_broker
- **Description**: ASP.NET Core 监听SQL Server数据库的实时信息
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 2
- **Forks**: 2
- **Created**: 2021-07-26
- **Last Updated**: 2024-09-05

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

1.开发环境：<br>
开发工具：Visual Studio 2019<br>
数据库：SQL Server2018<br>
开发环境：.Net 5<br>
2.使用技术：<br>
Signalr:实现消息推送<br>
SqlDependency：经过它的OnChangeEventHandler事件去监听数据库的波动【只针对SQL Serer】<br>
Microsoft.SqlSugar.Core:链接数据库<br>
SqlDependency:https://docs.microsoft.com/zh-cn/dotnet/framework/data/adonet/sql/detecting-changes-with-sqldependency<br>
3、注意事项：<br>
数据库需开启servicebroker<br>
use 【数据库名】<br>
go<br>

ALTER DATABASE 【数据库名】 SET NEW_BROKER WITH ROLLBACK IMMEDIATE; <br>

ALTER DATABASE 【数据库名】SET ENABLE_BROKER; <br>

SELECT is_broker_enabled FROM sys.databases WHERE name = '【数据库名】' <br>
<p>
数据库的所有者需改成登录用户
</p>