entity framework in mysql

浏览数：31 / 时间：2015年06月12日

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).