使用EF串連MySQL資料庫

標籤：data   structure   int   ssi   tco   northwind   var   連接字串   nfa   

使用Nuget載入包：EntityFramework，MySql.Data，MySql.Data.Entity檢查App.config或是web.config相關節點 1. EF配置節點

 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>10     <providers>11       <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />12     <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>13 </entityFramework>

 

2. MySQL配置節點

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. 連接字串

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>

 

使用EF串連MySQL資料庫