public void CanCreateTableWithMultiColumnForeignKey() { var expression = GeneratorTestHelper.GetCreateTableWithMultiColumnForeignKey(); var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE \"TestTable1\" (\"TestColumn1\" TEXT NOT NULL, \"TestColumn2\" INTEGER NOT NULL, CONSTRAINT \"FK_TestT_TestT\" FOREIGN KEY (\"TestColumn1\", \"TestColumn3\") REFERENCES \"TestTable2\" (\"TestColumn2\", \"TestColumn4\"))"); }