public void TestDatabaseCircular3FK()
        {
            var dd = new TestDatabaseCircular3FK();

            var a = dd.GetTable("A");
            var b = dd.GetTable("B");
            var c = dd.GetTable("C");

            var aCFK = a.Properties.OfType <CircularFK>().First();
            var bCFK = b.Properties.OfType <CircularFK>().First();
            var cCFK = c.Properties.OfType <CircularFK>().First();

            Assert.AreEqual("A", aCFK.SqlTable.SchemaAndTableName.TableName);
            Assert.AreEqual("B", bCFK.SqlTable.SchemaAndTableName.TableName);
            Assert.AreEqual("C", cCFK.SqlTable.SchemaAndTableName.TableName);

            Assert.AreEqual(3, aCFK.ForeignKeyChain.Count);
            Assert.AreEqual(3, bCFK.ForeignKeyChain.Count);
            Assert.AreEqual(3, cCFK.ForeignKeyChain.Count);

            Assert.AreEqual("A", aCFK.ForeignKeyChain.First().SqlTable.SchemaAndTableName.TableName);
            Assert.AreEqual("C", aCFK.ForeignKeyChain.Last().SqlTable.SchemaAndTableName.TableName);

            Assert.AreEqual("B", bCFK.ForeignKeyChain.First().SqlTable.SchemaAndTableName.TableName);
            Assert.AreEqual("A", bCFK.ForeignKeyChain.Last().SqlTable.SchemaAndTableName.TableName);

            Assert.AreEqual("C", cCFK.ForeignKeyChain.First().SqlTable.SchemaAndTableName.TableName);
            Assert.AreEqual("B", cCFK.ForeignKeyChain.Last().SqlTable.SchemaAndTableName.TableName);
        }
コード例 #2
0
        public void TestDatabaseCircular3FK()
        {
            var tables = new TestDatabaseCircular3FK().GetTables();

            Assert.AreEqual(3, tables.Count);

            CheckFK(tables, "A", "BId");
            CheckFK(tables, "B", "CId");
            CheckFK(tables, "C", "AId");
        }