Foreign keys not recognised

when generating an activerecord.cs from mysql using subsonic, some foreign keys are overlooked by the template. it acknowledges the table and columns, just not the relations.

i have checked all the basic things like made sure its the correct db, flushed tables, deleted classes etc.

the db is created using a dump. when i generate from this version everything works correctly. i then add some tables, which relate to existing ones. when i generate again, the new relations are missed by subsonic. the new tables have the same foreign key as existing ta开发者_StackOverflow社区bles.

ANY ideas will help me at this stage

thanks

---

solved it. although my connection string was correct(used for table generation), the following line was incorrect(used for foreign key generation) in Settings.ttinclude:

const string DatabaseName = "db";