C# / SQL Listener to tell me if a row has been ins

Question

Can someone post sample code or tell me how to set up a listener to notify me (trigger an event) if a new row is inserted into a SQL Server database?

I don't want to use any of the SQL Server messaging or broker services. I currently have a file listener which will notify me when new rows are appended to a flat file. I would like to do the same for a database table.

Answer 1

I would consider CLR trigger, Please read following articles...

Create Your First CLR Trigger in SQL Server

CLR Triggers