MySQL Forums
Forum List  »  MySQL for Visual Studio

Re: Visual Studio 2013 - ADO.net EF wizard closes unexpectedly when trying to create MySQL db models
Posted by: Gabriela Martinez Sanchez
Date: April 29, 2014 09:58AM

hi Avi,

Thanks for posting your question.

First I would recommend you to use the 1.1.4 version of the MySQL for Visual Studio since the 1.1.3 that you're using had an issue with EF 6 and VS 2013. Sorry for the inconvenience (download from http://dev.mysql.com/downloads/windows/visualstudio/).

Secondly please make sure you deleted any mysql assembly that is left in the Visual Studio folders that had not been copied by the product installer.
Once you install the 1.1.4 version please make sure you use the Connector/Net 6.8.3 and the MySQL for Visual Studio product.

If I understood correctly you are trying to generate an EF model using Database first approach. Here are the recommended steps so you model targets EF 6.

a. Add the reference for the new assembly called MySql.Data.Entity.EF6 and copy it to the bin forlder of your application.
b. Add the provider to your app/web config file on the providers for Entity Framework section with the following line:
<provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6"></provider>
c. Before you run the Wizard compile your application so the new changes are applied.
d. Start the EF wizard to make the Database First model.



If you want to do Model First please do the following
a. Add the reference for the new assembly called MySql.Data.Entity.EF6 and copy it to the bin forlder of your application.
b. Add the ADO.Net Entity Model new or existing.
c. Select the T4 template corresponding to MySQL (SSDLToMySQL)
d. Right click on the model and then select Generate Script to Create Database. (A MySQL script should be generated for you to create your database).


Hope this helps. Please let us know if this worked for you.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Visual Studio 2013 - ADO.net EF wizard closes unexpectedly when trying to create MySQL db models
6772
April 29, 2014 09:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.