refactoring option fboiton

gistfile1.cs

using Microsoft.SqlServer.Server;
using System.Data.SqlClient;

namespace BrokersWeb.Synchronization.SqlServer.Listings
{
     public static class ListingTriggers
    {
        [SqlTrigger(Name = "trig_listingmodified",
            Target = "ppc_t_account_profile",
            Event = "FOR INSERT, DELETE, UPDATE")]
        public static void WhenListingModified()
        {
            var context = SqlContext.TriggerContext;
            if (context.TriggerAction != TriggerAction.Insert
                    || context.TriggerAction != TriggerAction.Delete
                    || context.TriggerAction != TriggerAction.Update)
                return;

            var id = TriggersDao.GetInsertedPrimaryKeyValue<int>("account_profile_id");
            object message = ListingCommandFactory.GetCommand(id, context.TriggerAction);

            Bus.Instance.Send(message);
        }
    }
    public static class TriggersDao
    {
        public static T GetInsertedPrimaryKeyValue<T>(string fieldName)
        {
            var sql = string.Format("SELECT {0} FROM INSERTED", fieldName);
            var conn = new SqlConnection("context connection=true");
            conn.Open();
            var cmd = new SqlCommand(sql, conn);
            return (T)cmd.ExecuteScalar();
        }
    }
    public static class ListingCommandFactory
    {
        public static object GetCommand(int id, TriggerAction action)
        {
            if (action == TriggerAction.Insert)
                return new InsertListingCommand { Id = id };
            if (action == TriggerAction.Update)
                return new UpdateListingCommand { Id = id };
            return new DeleteListingCommand { Id = id };
        }
    }
	
}