entity framework in mysql

时间:2024-06-21 10:37:56

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

4.11 Using the ADO.NET Entity Framework

http://dev.mysql.com/doc/connector-net/en/connector-net-visual-studio-entity-framework.html

5.5 Tutorial: Using an Entity Framework Entity as a Windows Forms Data Source

http://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-entity-framework-winform-data-source.html

Chapter 10 EF 6 Support

http://dev.mysql.com/doc/connector-net/en/connector-net-entityframework60.html

more:

ASP.NET Identity: Using MySQL Storage with an EntityFramework MySQL Provider

http://www.asp.net/mvc/tutorials/security/aspnet-identity-using-mysql-storage-with-an-entityframework-mysql-provider