0

I have a back-end that synchronizes data from an ERP that's running in SQL Server.

I don't want to run select * from table where [not have processed filter] every second to catch new data.

When a new row is added to a specific table, I want to have some kind of event subscription that will cause my .NET Windows service to get this new data and just send it directly to the backend.

In the backend I already have a channel that receives the data and updates whoever is subscribed in the frontend.

I looked into Event Notification that exists since SQL Server 2016 but it doesn't look like what I'm looking for.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Yuval Lerner
  • 41
  • 2
  • 4

2 Answers2

1

Triggers on insert. You have to configure the connections between your data sources. Make sure to test your triggers thoroughly

Alex M
  • 141
  • 2
  • 6
1

I think you can use SignalR, these are samples can be useful:
https://stackoverflow.com/questions/11140164/signalr-console-app-example

SignalR-example2

hassan.ef
  • 1,300
  • 2
  • 11
  • 19