/// <summary>
/// Sets up the foreign key list
/// </summary>
public virtual void SetupForeignKeys()
{
for (int x = 0; x < ForeignKeyColumns.Count; ++x)
{
Database TempDatabase = ParentTable.ParentDatabase;
if (TempDatabase != null)
{
foreach (Table Table in TempDatabase.Tables)
{
if (Table.Name == ForeignKeyTables[x])
{
foreach (IColumn Column in Table.Columns)
{
if (Column.Name == ForeignKeyColumns[x])
{
ForeignKey.Add(Column);
break;
}
}
break;
}
}
}
}
}
/// <summary>
/// Sets up the foreign key list
/// </summary>
public void SetupForeignKeys()
{
var TempDatabase = ParentTable.Source;
if (TempDatabase is null)
{
return;
}
for (var x = 0; x < ForeignKeyColumns.Count; ++x)
{
for (int i = 0, TempDatabaseTablesCount = TempDatabase.Tables.Count; i < TempDatabaseTablesCount; i++)
{
var TempTable = TempDatabase.Tables[i];
if (TempTable.Name == ForeignKeyTables[x])
{
for (int j = 0, TempTableColumnsCount = TempTable.Columns.Count; j < TempTableColumnsCount; j++)
{
var TempColumn = TempTable.Columns[j];
if (TempColumn.Name == ForeignKeyColumns[x])
{
ForeignKey.Add(TempColumn);
break;
}
}
break;
}
}
}
}
