.net core+ef+mysql dbfist

 一、加三个包

Microsoft.EntityFrameworkCore.Tools

Microsoft.VisualStudio.Web.CodeGeneration.Design

MySql.Data.EntityFrameworkCore

二、程序包管理器控制台

Scaffold-DbContext -Force  "Server=localhost;User Id=root;Password=123456;Database=reserve" MySql.Data.EntityFrameworkCore -OutputDir Models

三、appsettings.json

"ConnectionStrings": { "conn":  "Server=localhost;User Id=root;Password=123456;Database=reserve" },

四、startup.cs  ConfigureServices方法中增加

services.AddDbContext<reserveContext>(Options => Options.UseMySQL(Configuration.GetConnectionString("conn")));

五、homecontroller

List<ReserveDepartment> Homes = _context.ReserveDepartment.ToList();
            return View(Homes);

六、view

@model IEnumerable<ReserveDepartment>

    <div class="text-center">
        <h1 class="display-4">Welcome</h1>
        @foreach (ReserveDepartment reserve in Model)
        {
            <div>@reserve.Code || @reserve.Name</div>
        }
    </div>

七、效果图

八、发布到IIS

安装DotNetCore.2.0.5-WindowsHosting.exe，不然可能会报“HTTP 错误 500.19 - Internal Server Error”

安装ASP.NET Core 2.2 Runtime (v2.2.2) - Windows Hosting Bundle Installer ，不然可能会报“HTTP 错误 500.21 - Internal Server Error”