Library for scripting SQL Server database objects with examples

using System.Collections.Specialized;
using System.Text;
using System;
using System.ComponentModel;


namespace ObjectHelper.DBObjectType
{
    public class Trigger:BaseDbObject
    {
        public int ParentClass { get; set; }
        public string ParentObjectName { get; set; }
        [DisplayName("Scheeeemaaaaaa")]
        public string Schema { get; set; }
        public string ParentObjectSchema { get; set; }
        public int ParentObjectId { get; set; }
        public bool IsDisabled { get; set; }
        public bool IsNotForReplication { get; set; }
        public bool IsInsteadOf { get;set;}
        public string Definition { get; set; }
        public bool IsAfter { get; set; }
        public bool IsDatabaseTrigger { get; set; }
        public StringCollection Events { get; set; }

        public Trigger()
        {
            Events = new StringCollection();
        }

        public string Script(ScriptingOptions so)
        {
            var sbScript = new StringBuilder();

            if (so.ScriptAnsiNulls)
            {
                sbScript.Append("SET ANSI_NULLS ON"+Environment.NewLine);
                sbScript.Append("GO" + Environment.NewLine);
            }
            if (so.ScriptQuotedIdentifiers)
            {
                sbScript.Append("SET QUOTED_IDENTIFIER ON" + Environment.NewLine);
                sbScript.Append("GO" + Environment.NewLine);
            }

            sbScript.Append(Definition.Trim() + Environment.NewLine + "GO" + Environment.NewLine);

            if (so.ScriptAnsiNulls)
            {
                sbScript.Append("SET ANSI_NULLS OFF" + Environment.NewLine);
                sbScript.Append("GO" + Environment.NewLine);
            }
            if (so.ScriptQuotedIdentifiers)
            {
                sbScript.Append("SET QUOTED_IDENTIFIER OFF" + Environment.NewLine);
                sbScript.Append("GO" + Environment.NewLine);
            }
            return (sbScript.ToString().Trim());
        }
    }
}