internal View(string viewName, DbConnection connection, ViewDesignerDoc parent)
{
_owner = parent;
_name = viewName;
_oldname = viewName;
_catalog = connection.Database;
_connection = connection;
_owner.Name = _name;
if (String.IsNullOrEmpty(viewName) == false)
{
using (DataTable tbl = connection.GetSchema("Views", new string[] { Catalog, null, Name }))
{
if (tbl.Rows.Count > 0)
{
_sql = tbl.Rows[0]["VIEW_DEFINITION"].ToString();
StringBuilder builder = new StringBuilder();
builder.Append(_sql);
builder.AppendLine(";");
_triggers.Clear();
_oldtriggers.Clear();
using (DataTable ttbl = _connection.GetSchema("Triggers", new string[] { Catalog, null, Name }))
{
foreach (DataRow row in ttbl.Rows)
{
ViewTrigger t = new ViewTrigger(this, row);
_triggers.Add(t);
_oldtriggers.Add(((ICloneable)t).Clone() as ViewTrigger);
builder.AppendFormat("{0};\r\n", t.OriginalSql);
}
}
_oldsql = builder.ToString();
}
else
{
_oldname = null;
}
}
}
}
internal View(string viewName, DbConnection connection, ViewDesignerDoc parent)
{
_owner = parent;
_name = viewName;
_oldname = viewName;
_catalog = connection.Database;
_connection = connection;
_owner.Name = _name;
if (String.IsNullOrEmpty(viewName) == false)
{
using (DataTable tbl = connection.GetSchema("Views", new string[] { Catalog, null, Name }))
{
if (tbl.Rows.Count > 0)
{
_sql = tbl.Rows[0]["VIEW_DEFINITION"].ToString();
StringBuilder builder = new StringBuilder();
builder.Append(_sql);
builder.AppendLine(";");
_triggers.Clear();
_oldtriggers.Clear();
using (DataTable ttbl = _connection.GetSchema("Triggers", new string[] { Catalog, null, Name }))
{
foreach (DataRow row in ttbl.Rows)
{
ViewTrigger t = new ViewTrigger(this, row);
_triggers.Add(t);
_oldtriggers.Add(((ICloneable)t).Clone() as ViewTrigger);
builder.AppendFormat("{0};\r\n", t.OriginalSql);
}
}
_oldsql = builder.ToString();
}
else
{
_oldname = null;
}
}
}
}
internal ViewTrigger(ViewTrigger source)
: base(source)
{
_triggerOccurs = (int)ViewTriggerOccurs.InsteadOf;
}
internal ViewTrigger(ViewTrigger source)
: base(source)
{
_triggerOccurs = (int)ViewTriggerOccurs.InsteadOf;
}
