How to work with SQL Server table dependency with ASP.NET Core скачать в хорошем качестве

How to work with SQL Server table dependency with ASP.NET Core

Hello everyone! I hope this video has helped solve your questions and issues. This video is shared because a solution has been found for the question/problem. I create videos for questions that have solutions. If you have any other issues, feel free to reach out to me on Instagram:   / ky.emrah   Below, you can find the text related to the question/problem. In the video, the question will be presented first, followed by the answers. If the video moves too fast, feel free to pause and review the answers. If you need more detailed information, you can find the necessary sources and links at the bottom of this description. I hope this video has been helpful, and even if it doesn't directly solve your problem, it will guide you to the source of the solution. I'd appreciate it if you like the video and subscribe to my channel!How to work with SQL Server table dependency with ASP.NET Core The context was the SQL Server table dependency not working, but my SignalR is working fine. There is no error showing its just that when I change some data through SSMS, the code below is firing. private void TableDependency_OnChanged(object sender, TableDependency.SqlClient.Base.EventArgs.RecordChangedEventArgs Announcement e) { if (e.ChangeType != TableDependency.SqlClient.Base.Enums.ChangeType.None) { announcementHub.NotifyAnnouncement(); } } private void TableDependency_OnChanged(object sender, TableDependency.SqlClient.Base.EventArgs.RecordChangedEventArgs Announcement e) { if (e.ChangeType != TableDependency.SqlClient.Base.Enums.ChangeType.None) { announcementHub.NotifyAnnouncement(); } } This is my code to handle when there is update from database: public async Task NotifyAnnouncement() { await Clients.All.SendAsync("ShowAnnouncement"); } public async Task NotifyAnnouncement() { await Clients.All.SendAsync("ShowAnnouncement"); } This is the code in my hub: const connection = new signalR.HubConnectionBuilder() .withUrl("/resident/home") .build(); connection.start().then(function () { alert('Connected to home'); }).catch(function (err) { return console.error(err.toString()); }); connection.on("ShowAnnouncement", function () { toastr.info("something new"); updateAnnouncement(); }); const connection = new signalR.HubConnectionBuilder() .withUrl("/resident/home") .build(); connection.start().then(function () { alert('Connected to home'); }).catch(function (err) { return console.error(err.toString()); }); connection.on("ShowAnnouncement", function () { toastr.info("something new"); updateAnnouncement(); }); This is my script on the client side - this code is working fine when I insert a new data through the system, because after inserting the data I put this code await _hubContext.Clients.All.SendAsync("ShowAnnouncement"); await _hubContext.Clients.All.SendAsync("ShowAnnouncement"); inside the controller. Then it reflects to my client side. I don't know if I should call the controller in SqlTableDependency code or is it possible to do, so that it reflects to the client side? SqlTableDependency I'm new to using SignalR and SqlTableDependency. Hope you understand thanks. SqlTableDependency I already enable the is_broker in the ssms. Tags: c#,sql-server,asp.net-core-mvc,signalrSource of the question: https://stackoverflow.com/questions/7... Question and source license information: https://meta.stackexchange.com/help/l... https://stackoverflow.com/