MySQL Forums
Forum List  »  MySQL for Visual Studio

How to start using Entity Framework 6 with MySQL databases
Posted by: Gabriela Martinez Sanchez
Date: November 28, 2013 10:52AM

To start using Entity Framework 6 and Visual Studio 2013 is necessary to install MySQL for Visual Studio 1.1.1 Beta and MySQL Connector/Net 6.8.1 Beta


MySQL for Visual Studio 1.1.1 Beta can be downloaded with the following link:
https://cdn.mysql.com/Downloads/MySQLInstaller/mysql-visualstudio-plugin-1.1.1.msi

MySQL Connector/Net 6.8.1 Beta
http://dev.mysql.com/downloads/connector/net/


To start working with VS 2013 and EF 6

1- Install the MySQL for Visual Studio 1.1.1
2- Install the Connector/Net 6.8.1 product.
3- To work with Database 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 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.
4- To work with 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 a bit.

Cheers,

Options: ReplyQuote


Subject
Views
Written By
Posted
How to start using Entity Framework 6 with MySQL databases
155379
November 28, 2013 10:52AM


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.