Raise event to WPF app from sql changes
I have an application in wpf which get live data from MSSQL and shows the data to client .I have another application that update or insert data in a regular interval. Is there any mechanism in MSSQL that automatically raise an event to wpf i have already read about SqlDependency. in SqlDependency there is an method OnChange(...) trigger continously. if there is insert or update or delete then via NamedPipe or Socket it can communicate to wpf application