MVC .NET CORE 学习之路一：与数据库进行交互

1>先在appsettings.json里面配置链接字符串

“ConnectionStrings”: {
“SqlServer”: “server=localhost;userid=sa;pwd=sa123;database=StudyNetCore”
}

2>在Startup里面进行sql链接注册服务

services.AddDbContext(optionsBuilder => {
var dataAppSetting = Configuration.GetConnectionString(“SqlServer”);
if (dataAppSetting == null)
{
throw new Exception(“未配置数据库连接”);
}

            optionsBuilder.UseSqlServer(Configuration.GetConnectionString("SqlServer")); //读取配置文件中的链接字符串
        });

3>通过控制输入命令自动生成实体

工具-》NuGet包管理器-》程序包管理器控制台
在其中输入以下命令：
Scaffold-DbContext “Data Source=[数据库IP];Initial Catalog=[数据库名称];persist security info=True;user id=[账号（用户名）];password=[密码];MultipleActiveResultSets=True;” Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models -Force -UseDatabaseNames

4>前后端调用

前端：
$.ajax({
url: “/Student/SaveStudent”,
type: “POST”,
contentType: “application/json”,
data: JSON.stringify({
“Name”: name, “Sex”: sex, “Age”: age, “Mobile”: mobile
}),
success: function (text) {
alert(text);
}
});
后端：

public IActionResult SaveStudent([FromBody]Dictionary<string, object> data)
{
var student = new Z_Student() {
ID= GetID(),
Name = GetNullValue(data[“Name”]),
Sex = GetNullValue(data[“Sex”]),
Age= GetNullValue(data[“Age”]),
Mobile = GetNullValue(data[“Mobile”])
};
context.Add<Z_Student>(student);
context.SaveChangesAsync();
return Json(“成功”);
}