.netcore 链接mysql的配置

在appsettings.json配置为：

namespace TodoApi

{

    public class Startup

    {      

        public voidConfigureServices(IServiceCollection services)

        {

            services.AddDbContext<TodoContext>(opt=>opt.UseMySql("Server=localhost;database=ThesisMgmt;uid=root;password=EaseSource"));

            services.AddMvc();

        }

 

        public voidConfigure(IApplicationBuilder app)

        {

            app.UseMvc();

        }

    }

将Todoapi.crproj配置为：

<Project Sdk="Microsoft.NET.Sdk.Web">

 

  <PropertyGroup>

   <TargetFramework>netcoreapp2.0</TargetFramework>

  </PropertyGroup>

 

  <ItemGroup>

    <FolderInclude="wwwroot\" />

  </ItemGroup>

 

  <ItemGroup>

    <PackageReferenceInclude="Microsoft.AspNetCore.All" Version="2.0.5" />

  </ItemGroup>

 

  <ItemGroup>

    <DotNetCliToolReferenceInclude="Microsoft.VisualStudio.Web.CodeGeneration.Tools"Version="2.0.2" />

    <PackageReferenceInclude="Pomelo.EntityFrameworkCore.MySql" Version="2.0.0"/>

  </ItemGroup>//数据库的相关配置

 

<ItemGroup>

<DotNetCliToolReferenceInclude="Microsoft.EntityFrameworkCore.Tools.DotNet"Version="2.0.0" />

</ItemGroup>

</Project>

执行命令：dotnet restore

 

执行命令：dotnet ef migrations add init

 

执行命令：Dotnet  ef  database  update