How to make SQL rise an event at SQL Client

Question

I need to create ConsoleApp in C# which is going to write something on local disk of client corresponding of data added to SQL Server by others. Now I do not know is there a way to SQL rise an event at client.
My idea is to periodicity check for new data by opening connection and selecting data.
Before I start coding Ill like to explore others ways of communicate from SQL Server to SQL Client.
Another idea is to make CLR at SQL side which is going to be triggered by trigger on table where data is inserted.

Answer 1

Perhaps Query Notifications is what you're looking for. Easy to use and quite reliable, in my experience.

You still have to make your query once, of course, but you sign up for events which let you know when the result set of the query have changed, so that you can then grab the new data.