public void SelfReferencingTableForeignKeyRelationshipContainsCorrectSelfReferences()
{
SelfReferencingTableDatabase database = new SelfReferencingTableDatabase();
DatabaseSchemaAndData databaseSchemaAndData = new DatabaseSchemaAndData(database);
Assert.AreEqual(1, databaseSchemaAndData.GenerateTableForeignKeyRelationshipTree(database.Table).Count);
}
public void TableForeignKeyRelationshipTreeIncludesBackwardsReferences()
{
ForeignKeyRelationshipTreeDatabase database = new ForeignKeyRelationshipTreeDatabase();
DatabaseSchemaAndData databaseSchemaAndData = new DatabaseSchemaAndData(database);
Assert.Contains(
new TableRelationship(-1, database.BackwardReferenceTable, database.RootTable),
databaseSchemaAndData.GenerateTableForeignKeyRelationshipTree(database.RootTable));
}