MySQL Bugs: #65161: Generating MySQL DDL from an Entity Framework Model

Bug #65161	Generating MySQL DDL from an Entity Framework Model
Submitted:	1 May 2012 9:48	Modified:	20 Jun 2016 13:36
Reporter:	Delush Fernando	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Connector / NET	Severity:	S2 (Serious)
Version:	6.5.4	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	Generating MySQL DDL from an Entity Framework Model

Description:
20.2.4.9. Tutorial: Generating MySQL DDL from an Entity Framework Model

this works fine till the last finish button and then it shows that data base is not connected and when try to connect it only appear the SQL server not MYSQL
I tried many times but only the MySQL server engine popups

How to repeat:
can't connect to MYSQL engine because only SQL Server Connection comes

Thanks for reporting the problem in Connector/NET.
In order to resolve it or advise a workaround I need answers to the following
questions:

 1. Which version of Visual Studio you are using?

 2. Please provide the exact steps how you tried to add a connection into
    the server explorer (such as all menu/button/dialog names).

 3. Check your machine.config files (for NET Framework v2.0 and v4.0) and 
    make sure they contain the entries for MySQL Connector 6.5.4

Thanks.

I'm Using Visual Studio 2010 Sp1

I did Exactly as the below tutorial says

 http://dev.mysql.com/doc/refman/5.0/en/connector-net-tutorials-efmodel-ddl.html

at the end when after I press the Finish Button
the DLL that was generated stop executing and displays the Database is not connected.
when I tried to connect it from database connect button, it pop ups the interface for MSSqlServer Engine not any MySql connection.

This happens only when trying to Generate Database from Model and Generating Model from Database work fine 
I tried many times but still get the same problem and no way to connect MySql Data base from that point.

But it works fine with MSSqlServer because when try to connect database it pop up MSSqlServer Engine.

Thank you

Apart from the tutorial for Entity Framework Model, did you try creating a new connection in the Server Explorer before starting with the tutorial steps?

Can you try to create the connection and then repeat the same steps using the connection created before rather then trying to make it in the middle of the process?

I tried many things including what you have asked to do but same result.
I'll try with an old connector tomorrow and tell you the result.

thanks

screenshot with different data sources

Attachment: net_data_source.png (image/png, text), 28.58 KiB.

Please check the screenshot I uploaded.
Do you see "MySQL Database" in the list when click [Add Connection] in the Solution Explorer then click "Change..." button?

Also, as I said before, you need to find machine.config file and make sure Connector/NET 6.5.4 is registered there.

Yes I check the screenshot you uploaded.
And yes I can see "MySQL Database" in the list when click [Add Connection] in Server Explorer when  click "Change..." button. Not in Solution Explorer.

Also I checked in machine.config file and Connector/NET 6.5.4 is registered in it.

Thanks

Sorry for the typo mistake, I wanted to say Server Explorer instead of Solution Explorer.
So, you have confirmed that MySQL Database is in the list of available data sources. What happens when you select it and click "OK" button?

it works fine and connect to MySQL but the problem comes only when I try to update or generate database from the model.
then it asks to connect to database but only show the MS SQLServer engine interface and no way to connect my SQL...

thank you

All steps work perfectly for me.
In the "Generate Database Wizard" you can either choose previously created connections in the drop-down list or create a new connection by clicking "New Connection" button.

Does Visual Studio display MySQL connections in the drop-down list as shown on the screenshot (generate_db_wizard.png)?

Maybe you should close Visual Studio and re-install MySQL Connector/NET.

Generate Database Wizard with MySQL data

Attachment: generate_db_wizard.png (image/png, text), 50.21 KiB.

Can you please give me an email address then I can send you the screenshots of what's going wrong ok because it's very hard for me to explain.
my email delush@gamil.com.

Thank you,
regards.
Sasanka

Can you please give me an email address then I can send you the screenshots of what's going wrong ok because it's very hard for me to explain.
my email delush@gmail.com.

Thank you,
regards.
Sasanka

You can send screenshots on my email address bogdan.degtyariov@oracle.com 
(by the way, it is specified in the link anchored to my name for every comment).

Alternatively, you can use the Files tab. However, the maximum file size is
limited to 500kb, which is not a problem if you upload jpg or png screenshots.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

work fine with Telerik version

I'll upload error with screen shots soon as possible

Hi,

Are you still getting this problem?

If so, can you reproduce the issue running Visual studio with log enabled (devenv.exe /log) and upload the log file? which must be in a path like:
%APPDATA%\Roaming\Microsoft\VisualStudio\<version>\ActivityLog.xml.

if you prefer, you can send it directly to fer dot gonzalez at oracle dot com.

Thanks.

It's not throwing any error, the only problem is there is no way to connect to MySQL database when want to update database from model.

thanks

Hello Delush Fernando,

Thank you for your feedback.
I could not repeat the issue at our end using with Visual Studio 2013, Connector/NET 6.9.8 and MySQL for Visual Studio 1.2.6.
If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Could you please try with latest versions Connector/NET and  MySQL for Visual Studio
https://dev.mysql.com/downloads/connector/net/
https://dev.mysql.com/downloads/windows/visualstudio/

Thank you for your interest in MySQL.

Thanks,
Chiranjeevi.