Real time link between SQL and App

[stepcicc]

Hi, hope soemone can help with this...

As soon as a specific SQL table receives an insert our application should be aware of this. Based upon certain other createria the application will then perform certain functions. How can one do this without having the application to do a select query to SQL every second? Sending emails from SQL will also not do. It has to be realtime....

 

[jmcilhinney]

I've only played with it in a very cursory fashion myself but you should look at the SqlDependency class.