MySQL Bugs: #62150: EF4.1, Code First, CreateDatabaseScript() generates an invalid MySQL script

Bug #62150	EF4.1, Code First, CreateDatabaseScript() generates an invalid MySQL script
Submitted:	12 Aug 2011 7:49	Modified:	12 Apr 2012 6:08
Reporter:	Leonard Wennekers	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / NET	Severity:	S3 (Non-critical)
Version:	6.4.3	OS:	Any
Assigned to:	Fernando Gonzalez.Sanchez	CPU Architecture:	Any
Tags:	Code First, CreateDatabaseScript(), Entity Framework 4.1

Description:
Entity Framework 4.1 and Code First
The MySQL script generated by using the function CreateDatabaseScript is incorrect. It doesn't take in account the pluralization. Even the function .ToTable("TableName") isn't taken in account. Therefor the generated MySQL script is incorrect.

How to repeat:
Always

Thanks for your report Leonard,

However this was fixed in v6.4.4 as part of the fix for http://bugs.mysql.com/bug.php?id=61230.

As such I cannot reproduce it.

Can you confirm this is fixed?

Thanks.

If've checked it on 6.4.4 and there it seams to be corrected. However it's only corrected for the create table command the alter table command is still singular

Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/

This fix will appear in versions 6.3.9, 6.4.5 & 6.5.1.

I tested it with version 6.4.4 and it still gave the same errors.
I tested it with version 6.5.0 and it still gave the same errors.

I tested it with version 6.5.1 and there where improvements. Pluralization for the alter table command for the primary key is corrected, however the the alter table command for the foreign keys is still singular.

I hope this will help you with fixing this problem.

Added to changelog for 6.4.5, 6.5.2: 

The MySQL script generated by using the function CreateDatabaseScript
used names with incorrect singular/plural forms.

Added also to changelog for 6.3.9.

Thanks for the good work. Tested it with 6.5.4 a it all seamed to be as I expected. Thanks again.
Leonard Wennekers