madan mishra

madan mishra

  • NA
  • 1
  • 1k

Raise event to WPF app from sql changes

Aug 18 2014 8:41 AM
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