Passing values from SQL to WCF
<p>Am using CLR Trigger to pass the values to WCF,everything works fine but when try to pass the constant value its not pass thru WCF even its not throwing any exception.</p>

<p><strong>CLR Trigger</strong></p>

<pre><code>public partial class Triggers
{

    public static EndpointAddress endpoint = new EndpointAddress(new Uri("http://localhost:8000/services/myservice"));
    public static WSHttpBinding httpBinding = new WSHttpBinding();
    public static ServiceClient.ServiceReference1.ServiceContractClient myclient = new ServiceClient.ServiceReference1.ServiceContractClient(httpBinding, endpoint);
    public delegate void MyDelagate(String crudType);
    [SqlProcedure()]

    [Microsoft.SqlServer.Server.SqlTrigger(Name = "WCFTrigger",
       Target = "tbCR", Event = "FOR UPDATE, INSERT")]
    public static void Trigger1()
    {
        SqlCommand cmd;
        SqlTriggerContext myContext = SqlContext.TriggerContext;
        SqlPipe pipe = SqlContext.Pipe;
        SqlDataReader reader;

        if(myContext.TriggerAction== TriggerAction.Insert)
        {
            using (SqlConnection conn = new SqlConnection(@"context connection=true"))
            {
                conn.Open();
                cmd = new SqlCommand(@"SELECT * FROM tbCR", conn);
                reader = cmd.ExecuteReader();
                reader.Read();

                //get the insert value's here
                string Name;
                Name = reader[1].ToString();
                reader.Dispose();
                myclient.InsertOccured(Name);
                }
            }
        }

    }
}
</code></pre>

<p><strong>Interface</strong></p>

<pre><code>namespace SampleService
{
    [ServiceContract]
    interface IServiceContract
    {
        [OperationContract]
        void UpdateOccured();
        [OperationContract]
        void InsertOccured(String Name);
    }
}
</code></pre>

<p><strong>Contract</strong></p>

<pre><code>namespace SampleService
{
    class MyService : IServiceContract
    {
         public void InsertOccured(string Name)
        {
            Console.WriteLine("Insert Occured",Name);
        }

    }
}
</code></pre>

<p>every time i insert record ,WCF shows "Insert Occured" only but i was expecting "Insert Occured, Test".</p>

<p>Can you please guide me what i suppose to do to get the constant value from SLQ Tirgger.</p>
