3

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 have done lot of research on how to implement it using MySQL. But didn't find anything useful.

Please guide me if there is something I can try with MySQL to achieve this ?

Thanks.

H. Mahida
  • 2,356
  • 1
  • 12
  • 23
Dev
  • 309
  • 1
  • 8
  • 24

1 Answers1

0

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

Anders
  • 17,306
  • 10
  • 76
  • 144