1. 配置一:
配置好ConnectionStrings,通过ConnectionString动态读取ServerVersion。推荐使用
appsettings.json
"ConnectionStrings": {
"MoviesDBContext": "server=127.0.0.1;port=3306;uid=root;pwd=123456;database=MoviesDB"
}
Program.cs
using Microsoft.EntityFrameworkCore;
using RpMoviesDemo.Models;
var mySqlConnStr = builder.Configuration.GetConnectionString("MoviesDBContext") ?? throw new InvalidOperationException("Connection string 'MoviesDBContext' not found.");
// 使用My Sql数据库
builder.Services.AddDbContext<MoviesDBContext>(options =>
options.UseMySql(mySqlConnStr, ServerVersion.AutoDetect(mySqlConnStr