ADO.NET Entity Generation Wizard Taking Hours

Question

Hello,

I'm currently working with Visual Studio 2008 and the ADO.NET Entity Data Model Wizard. I'm connecting to a MySQL database using the MySQL/Connector plug in available. I have a database with 63 tables, each with foreign key constraints on several columns.

I'm working on the data access layer for a multi-tier system. The ADO.NET Entity Data Model Wizard is taking hours to update the edmx file from the database. This happens with the initial import the wizard performs and also when I need to "Update model from database". This means every time I make a small change to the database I have to wait for 2 hours for the model to update.

This only seems to happen if I have foreign key constraints enabled.

Is this a known issue? Is this happening simply because of the amount of tables I have? Maybe this could be because of the MySQL connector?

Any insight to the source of this issue or workaround/fix would be apprciated.

Thanks Christopher Hemple

Answer 1

Hi! First sorry for my English =) Have you found a solution for faster EF model generation for MySQL database with keys? regards, Khilko Pavel. [email protected] ICQ 245188743