Live data updating in Blazor
Providing live data updates or data synchronization in a multi-user environment has always been a bit challenging. I have been chasing how to do live updates and day sync between desktop applications, web applications, and even temporarily disconnected clients. I have worked with Sales applications and legal applications where users needed to work but did not have access to the internet or a network. Even though I was able to provide a solution, they were too complex and too hard to maintain for what I care for. Thanks to ZetBit , I was able to find an awesome solution to move forward with. This solution is only using Microsoft SQL Server and a cool Nuget package called SQLTableDependancy . For this solution, you need to enable the Service Broker in SQL Server. This will generate events when records in the database are added, edited, or deleted. Using the SQLTableDependancy class you set event listeners for what tables you want to listen to. Th...