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