internal void CleanUp()
{
try
{
var delList = new ArrayList();
//Remove orphaned columns
foreach (Column column in this.Database.Columns)
{
if ((column.ParentTableRef == null) ||
(column.ParentTableRef.Object == null) ||
(column.ParentTableRef == null) ||
(column.ParentTableRef.Object == null))
{
delList.Add(column);
}
}
foreach (Column column in delList)
this.Database.Columns.Remove(column);
//Remove orphaned relations
delList = new ArrayList();
foreach (Relation relation in this.Database.Relations)
{
if ((relation.ParentTableRef == null) ||
(relation.ParentTableRef.Object == null) ||
(relation.ParentTableRef == null) ||
(relation.ParentTableRef.Object == null))
{
delList.Add(relation);
}
else if (!relation.FkColumns.Any())
{
delList.Add(relation);
}
}
foreach (Relation relation in delList)
this.Database.Relations.Remove(relation);
}
catch (Exception ex)
{
throw;
}
}