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