title: Can I call a C# function by a SQL Server trigger?
body: <p>An external application come to my database for inserting row in a Sql server table.</p>
  
  <p>I have a web application on my own, and I want on each insert in this table, do some treatement server side.</p>
  
  <p>My idea is to create a trigger on insert on the table, and then call appropriate function.</p>
  
  <p>What is the best way to do this ? </p>
  
  <p>I use framework 3.5 with LINQ to SQL, and a SQL Server 2005 database.</p>
  
  <p><strong>Edit</strong> : Thank you for the answers.
  SQL Server CLR integration doesn't do it. The few libraries supported doesn't meet me requirement.</p>
  
  <p>The table I have to log will take a new record every 5 minutes perhaps, not so much.
  Maybe I can have a job listening at the table every minute, look at the ID, take all the new ID, do my treatement.
  Is my solution not too ugly ?</p>