Using Foreign Key And Multiple Schema with MYSqlInnoDbProvider

 Hi,

We have 2 schema on the same MYSQL Server.

The Tables are in InnoDb Format, and we have Foreign Key crossing over the 2 schema.

Is there a way to have the DAL running well in this config?

Does Subsonic allow Foreign Key acrossing schemas, and should it work?

We try to set 2 provider, 2 GeneratedNameSpace (one on each schema), and 2 connection string well linked to our providers, and the model of our tables in the second schema doesn't generate.

Thanks in advance for your help.

Hi,

I really need Help about that, Thank in advance if somebody can help me....

PLEASE ???