使用 mysql 可以下载 Pomelo.EntityFrameworkCore.MySql 包
链接语句改成:
services.AddDbContext<AppDbContext>(options =>options.UseMySql(Configuration.GetConnectionString("MySqlConnection"), new MySqlServerVersion(new Version(8, 0, 28))));
配置:
"ConnectionStrings": {
"DefaultConnection": "Server=(localdb)\\MSSQLLocalDB;Database=LanzhouNoodleDb;Trusted_Connection=True;MultipleActiveResultSets=true",
"MySqlConnection": "Server=localhost;database=LanzhouNoodleDb;uid=root;pwd=12345678;"
},
var host = CreateHostBuilder(args).Build();
using (var scope = host.Services.CreateScope())
{
var services = scope.ServiceProvider;
try
{
var context = services.GetRequiredService<AppDbContext>();
DbInitializer.seed(context);
}
catch (Exception)
{
//故意留空,以后可以添加日志
}
}
host.Run();
只有预先完成项目构建,entityframework才能在数据库上下文中找到各种模型的引用。
add-migration xxx
update-database