Catch/Raise event on table data update C#

Question

Hi,

I have 24/7 service which keeps setup (configuration data) for charging, routing and etc in the Sql Server. Once it is started it loads the data from table using Linq2SQL and use the data through all the application. And we need a solution to update the setup data in the table without restarting the application. So I am interested is it possible to catch/determine that the table was updated so I can refresh the setup data in the application. I mean is it possible to have events which will raise when there is any delete, update or insert on the table.

Thank you.

Answer 1

You're looking for the SqlDependency class.

Answer 2

SQL Server has the @@ROWCOUNT function, it will tell you how many rows were affected. Not sure how you would get to it from LINQ

I mean is it possible to have events which will raise when there is any delete, update or insert on the table.

On the database side this can be accomplished with a trigger