Bug #76175 EF 6 Database.Create Crash
Submitted: 5 Mar 2015 15:04 Modified: 12 Mar 2015 13:05
Reporter: Brian Dahl Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:6.9.6 OS:Windows
Assigned to: CPU Architecture:Any

[5 Mar 2015 15:04] Brian Dahl
Description:
Hello,
i had made a Project in Vs2013 with the Entity Framework 6 and i want to Create a new Database. I had tested with context.Database.Initialize and with context.Database.Create but everytime i receive the same exception: ""You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( 20, 2 )  NOT NULL, \r\n\t`Aktienanzahl` BIGINT UNSIGNED( 20, 2 )  NOT NULL, \r\n\t`W' at line 12"}"
I use the Codefirst Approach.
Does anybody know how can i debug the creation String in Modelfirst

How to repeat:
Prereq: C# .Net 4.5; VS2013; MySQL Connector 6.9.6

Make a new ADO.NET Class with MySql Settings (Modelfirst);
If the Database didnĀ“t exist call Context.Database.Create(); after a while i receive the Exception.
[8 Mar 2015 15:14] Brian Dahl
i had forgotten to set the right Severity....
[11 Mar 2015 5:36] Chiranjeevi Battula
Hello Brian Dahl,

Thank you for the bug report.
I could not repeat the issue on Visual Studio 2013 (C#.Net) with  MySQL Connector/Net 6.9.6. Could you please provide complete repeatable test case to confirm this issue at our end?

Thanks,
Chiranjeevi.
[12 Mar 2015 13:05] Brian Dahl
Ok i had solved the Problem... I had inserted the mysql libs via nuget but there are old Libs... If i had installed the mysql for visual Studio there were the newest one, and after that i had changed the old libs to new one it has solved the Problem...