ContosoUniversity MVC5 + EF6 code first approach using MySQL example download:
https://sites.google.com/site/szmulder/Home/contosouniversity-mvc5-ef6-code-first-approach-using-mysql/ContosoUniversity.zip
To start using Entity Framework 6 and Visual Studio 2013 is necessary to install
MySQL for Visual Studio 1.1.1
MySQL Connector/Net 6.8.3 GA
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.3 GA
http://dev.mysql.com/downloads/connector/net/
To start working with VS 2013 and EF 6
1. Uninstall old version MySQL for Visual Studio and Connector/Net
2. Install the MySQL for Visual Studio 1.1.1
3. Install the Connector/Net 6.8.3 product
4. Add the reference for MySql.Data, MySql.Data.Entity.EF6, MySql.Web (Version 6.8.3.0) assembly into the project. Depending on the .NET Framework used, the assembly is to be taken from either the v4.0 or the v4.5 folder).
5. Edit web.config or app.config
<connectionStrings>
<add name="SchoolContext" connectionString="Data Source=xxxxx;port=3306;Initial Catalog=ContosoUniversity;user id=root;password=xxxxxxxxx;" providerName="MySql.Data.MySqlClient"/>
</connectionStrings>
<entityFramework codeConfigurationType="MySql.Data.Entity.MySqlEFConfiguration, MySql.Data.Entity.EF6">
<defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework"/>
<providers>
<provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6" />
<provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
</providers>
<contexts>
<context type="ContosoUniversity.DAL.SchoolContext, ContosoUniversity">
<databaseInitializer type="ContosoUniversity.DAL.SchoolInitializer, ContosoUniversity"/>
</context>
</contexts>
</entityFramework>
6. Edit SchoolContext.cs
....
using MySql.Data.Entity;
namespace ContosoUniversity.DAL
{
[DbConfigurationType(typeof(MySqlEFConfiguration))]
public class SchoolContext : DbContext
{
....
}
}
7. Edit Global.asax.cs
......
using MySql.Data.Entity;
namespace ContosoUniversity
{
public class MvcApplication : System.Web.HttpApplication
{
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
DbConfiguration.SetConfiguration(new MySqlEFConfiguration());
}
}
}