/// <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; } } } }