C#

public partial class Triggers
{
    // Enter existing table or view for the target and uncomment the attribute line
    [Microsoft.SqlServer.Server.SqlTrigger(Name = "StockTradInsertTrigger", Target = "STOCK_TRADES", Event = "FOR INSERT")]
    public static void StockTradInsertTrigger()
    {

        SqlTriggerContext triggContext = SqlContext.TriggerContext;

        if (triggContext.TriggerAction == TriggerAction.Insert)
        {
            using (SqlConnection connection = new SqlConnection("context connection=true"))
            {
                connection.Open();
                SqlCommand sqlComm = new SqlCommand();

                sqlComm.Connection = connection;
                sqlComm.CommandText = /*"SELECT STOCK_EVALUATOR_IP from EXCHANGE_STOCKS where STOCK_ID = */"(SELECT STOCK_ID from INSERTED)";
                try
                {
                    string userType = sqlComm.ExecuteScalar().ToString();
                    SqlContext.Pipe.Send("This is the IP of Stock Evaluator System = "+userType);
                    oiStockEvaluatorService service = new oiStockEvaluatorService();
                    service.Enqueue(Convert.ToInt32(userType));
                }
                catch (Exception ex)
                {
                    SqlContext.Pipe.Send("exception = " + ex.Message);
                    //FileStream fl = new FileStream(@"C:\test.txt", FileMode.OpenOrCreate, FileAccess.Write);
                    //fl.Write(Convert.FromBase64String(ex.Message + System.Environment.NewLine), 0, ex.Message.Length);
                }
            }
        }

        // Replace with your own code
        SqlContext.Pipe.Send("Trigger FIRED");
    }