I want to raise an event in C# when any one user make an insert or an update to a certain table in SQL server via my C# program. As there are multiple users using the execution file in various locations, I can not do it using the C# cord alone.
For example, as soon as a new order is added in Reception, the kitchen must get a pop up with the details of the last order. I have used timer event and checked whether new records are there, but it is not good.
Please help.
Thanks in advance.