Hello i am looking for a technology which can help firing event开发者_开发百科 after someone put the row into sql and this even will be transfer to some c# listner application, or this event will fire some c# application. Is this possible? I am using sql 2008 web server
You can create a SQL Server trigger on the Table, and in the trigger you can invoke a CLR Stored Procedure.
Depends on the DB your using to how Exactly to implement. But you need to look into triggers. These are chunks of code that reside on the database that can be told To do something on certain database actions like on insert, on delete etc
精彩评论