Broadcast The Real Time MySQL Database Table Data

I need to broadcast the real time database table to my web application (Asp.net). I know I can implement it using SignalR and SqlDepedency. But the issue is my database is MySQL. I

Solution 1:

You should avoid SqlDep. anyway. I always recommend publishing database changes on a service bus and let signalr pick it up. This way you can fire state changes anyware in your domain and signalr can pick it up

Check this library out to abstract signalr from your backend bus (I'm the author)

https://github.com/AndersMalmgren/SignalR.EventAggregatorProxy/wiki