protected virtual SchemaResult SetForeignKey(Table table, Table target, ForeignKeyColumn fk)
{
CurrentSchema.AddForeignKey(fk);
table.RemoveColumn(fk.Name);
table.AddColumn(fk);
target.ReferencingForeignKeys = GetReferencingForeignKeysForTable(target.Name);
table.ForeignKeys = GetForeignKeysForTable(table.Name);
if (AutoSave)
{
CurrentSchema.Save();
}
return(new SchemaResult("ForeignKeyColumn set"));
}
public override BAS.ForeignKeyColumn[] GetForeignKeyColumns()
{
DataTable foreignKeyData = GetForeignKeyData(_daoDatabase);
List <BAS.ForeignKeyColumn> results = new List <BAS.ForeignKeyColumn>();
foreach (DataRow row in foreignKeyData.Rows)
{
BAS.ForeignKeyColumn fk = new BAS.ForeignKeyColumn();
fk.TableName = row["ForeignKeyTable"].ToString();
fk.ReferenceName = row["ForeignKeyName"].ToString();
fk.Name = row["ForeignKeyColumn"].ToString();
fk.ReferencedKey = row["PrimaryKeyColumn"].ToString();
fk.ReferencedTable = row["PrimaryKeyTable"].ToString();
results.Add(fk);
}
return(results.ToArray());
}
public void SetPropertyName(string columnName, string propertyName)
{
List <Column> columns = new List <Column>(Columns);
Column toSet = columns.FirstOrDefault(c => c.Name.Equals(columnName));
if (toSet != null)
{
toSet.PropertyName = propertyName;
Columns = columns.ToArray();
}
else
{
List <ForeignKeyColumn> fks = new List <ForeignKeyColumn>(ForeignKeys);
ForeignKeyColumn toSetFk = fks.FirstOrDefault(c => c.Name.Equals(columnName));
if (toSetFk != null)
{
toSetFk.PropertyName = propertyName;
ForeignKeys = fks.ToArray();
}
}
}
public void WriteReferencingList(ForeignKeyColumn fk)
{
Write(fk.RenderListProperty());
}
public void WriteAddToChildDaoCollection(ForeignKeyColumn fk)
{
Write(fk.RenderAddToChildDaoCollection());
}
public void WriteForeignKeyColumnProperty(ForeignKeyColumn fk, int num)
{
Write(fk.RenderClassProperty(num, Namespace));
}