protected void LoadTriggerRelationships()
        {
            DataTable trigs = new DataTable();

            using (SqlConnection conn = new SqlConnection(ConnectionStringBuilder.ConnectionString))
            {
                conn.Open();
                using (SqlDataAdapter sda = new SqlDataAdapter(TRIGGER_QUERY, conn))
                {
                    sda.Fill(trigs);
                }
                conn.Close();
            }
            foreach (DataRow trow in trigs.Rows)
            {
                string tblname  = trow["table_name"].ToString();
                string trigname = trow["trigger_name"].ToString();

                SqlServerTriggerNode trignode = trigList.Where(t => t.ObjectName == trigname).SingleOrDefault();
                SqlServerTableNode   tblnode  = tableList.Where(t => t.ObjectName == tblname).SingleOrDefault();
                if (trignode != null && tblnode != null)
                {
                    DataConnection trigrel = new DataConnection
                    {
                        ConnectionType = DbProcesses.Trigger,
                        StartNode      = trignode,
                        EndNode        = tblnode,
                        Name           = String.Format("Trigger {0} => {1}.{2}", trignode.ObjectName, tblnode.Schema, tblnode.ObjectName),
                        Description    = "Table Trigger"
                    };
                    Relationships.Add(trigrel);
                }
            }
        }
        protected List <SqlServerTriggerNode> LoadTriggers()
        {
            List <SqlServerTriggerNode> tlist = new List <SqlServerTriggerNode>();
            DataTable trigs = new DataTable();

            using (SqlConnection conn = new SqlConnection(ConnectionStringBuilder.ConnectionString))
            {
                conn.Open();
                using (SqlDataAdapter sda = new SqlDataAdapter(TRIGGER_QUERY, conn))
                {
                    sda.Fill(trigs);
                }
                conn.Close();
            }
            foreach (DataRow trow in trigs.Rows)
            {
                SqlServerTriggerNode tnode = new SqlServerTriggerNode(trow["trigger_name"].ToString(), ConnectionStringBuilder);
                tnode.Schema     = trow["table_schema"].ToString();
                tnode.ObjectName = trow["trigger_name"].ToString();
                List <string> ancestry = new List <string>();
                ancestry.Add(Name);
                ancestry.Add(tnode.Schema);
                ancestry.Add(trow["table_name"].ToString());
                tnode.Lineage = CreateNameSpace(ancestry);
                tlist.Add(tnode);
            }
            return(tlist);
        }