Connect to MySQL database using EF

To load a package with NuGet: entityframework,mysql.data,mysql.data.entity Check app. config or Web. config related nodes 1. EF Configuration Node

1<configSections>2<section name="EntityFramework"Type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, version=6.0.0.0, culture= Neutral, publickeytoken=b77a5c561934e089"requirepermission="false"/>3</configSections>4<entityFramework>5<defaultconnectionfactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">6<parameters>7<parameter value="Mssqllocaldb"/>8</parameters>9</defaultConnectionFactory>Ten<providers> One<provider invariantname="System.Data.SqlClient"Type="System.Data.Entity.SqlServer.SqlProviderServices, Entityframework.sqlserver"/> A<provider invariantname="MySql.Data.MySqlClient"Type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6, version=6.9.9.0, Culture=neutral, PUBLICKEYTOKEN=C5687FC88969C44D"></provider></providers> -</entityFramework>

2. mysql Configuration node

1<system.data>2<DbProviderFactories>3<remove invariant="MySql.Data.MySqlClient"/>4<add name="MySQL Data Provider"Invariant="MySql.Data.MySqlClient"description=". Net Framework Data Provider for MySQL"Type="MySql.Data.MySqlClient.MySqlClientFactory, Mysql.data, version=6.9.9.0, Culture=neutral, publickeytoken= C5687FC88969C44D"/>5</DbProviderFactories>6</system.data>

3. Connection string

1 <connectionStrings>2     <add name="northwindconnection" connectionstring="Data source=localhost;port=3306;initial catalog=northwind;user id=developer; Password=developer; " 3          Providername="MySql.Data.MySqlClient" />4 </connectionstrings >

Connect to MySQL database using EF