1.创建项目
屏幕快照 2018-12-14 23.22.23.png
2.添加依赖项
屏幕快照 2018-12-14 23.23.55.png
屏幕快照 2018-12-14 23.24.24.png
3.添加数据库字符串
在appsetting.json中添加数据库信息
"DefaultDbConnect": "server=localhost;database=demo;user=root;password=123456"
数据库名称为demo，创建一个user表
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
INSERT INTO `demo`.`user`(`username`) VALUES ('rookie')
4.
在Model中创建一个ApplicationDbContext.cs和User.cs
屏幕快照 2018-12-14 23.30.12.png
using Microsoft.EntityFrameworkCore;
namespace ConnectMySQLDemo.Models
{
public class ApplicationDbContext:DbContext
{
public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options)
{
}
public DbSet<User> user{ get; set; }
}
}
namespace ConnectMySQLDemo.Models
{
public class User
{
public int Id { get; set; }
public string username { get; set; }
}
}
5.在Startup中配置mysql
屏幕快照 2018-12-14 23.37.33.png
// Mysql
IConfigurationSection configurationSection = Configuration.GetSection("DefaultDbConnect");
services.AddDbContext<ApplicationDbContext>(options => options.UseMySql(configurationSection.Value));
6.在Controller中测试
在HomeController中查询，然后在index.cshtml中显示
屏幕快照 2018-12-14 23.43.49.png
屏幕快照 2018-12-14 23.49.00.png
屏幕快照 2018-12-14 23.49.08.png
HomeController.cs代码如下
private ApplicationDbContext _db;
public HomeController(ApplicationDbContext db)
{
_db = db;
}
public IActionResult Index()
{
var item = _db.user.FirstOrDefault(u => u.Id == 1);
return View(item);
}
index.html代码如下
@model User
@{
ViewData["Title"] = "Home Page";
}
<h1>@Model.Id</h1>
<div>@Model.username</div>
7.运行
屏幕快照 2018-12-14 23.51.42.png
屏幕快照 2018-12-14 23.52.11.png
完成
