ASP.NET MVC使用MySQL数据库

最新推荐文章于 2024-08-11 00:19:24 发布

干到60岁退休的码农

最新推荐文章于 2024-08-11 00:19:24 发布

阅读量9k

点赞数

分类专栏： ASP.NET MVC 文章标签：数据库 asp.net mvc mysql

本文链接：https://blog.csdn.net/gary_888/article/details/72831950

版权

ASP.NET MVC 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

1.新建MVC Web项目；
2.打开管理Nuget程序包搜索:MySql.Data && MySql.Data.Entity 点击安装
3.修改连接字符串(默认是SqlServer)

<add name="DefaultConnection" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\aspnet-Gary.Web-20170523110735.mdf;Initial Catalog=aspnet-Gary.Web-20170523110735;Integrated Security=True" providerName="System.Data.SqlClient" />
    <!--<add name="GaryDBContext" connectionString="Data Source=127.0.0.1;Initial Catalog=GaryWeb;Integrated Security=True;User Id=sa;Password=123456"
         providerName="System.Data.SqlClient" />-->
    <add name="GaryDBContext" connectionString="Data Source=127.0.0.1;Database=GaryWeb;User Id=root;Password=123456;charset=utf8;port=3306"
         providerName="MySql.Data.MySqlClient" />

4.修改providers

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