在Vs2022 NuGet安装套件

Install-Package Pomelo.EntityFrameworkCore.MySql

Install-Package Microsoft.EntityFrameworkCore.Design
Install-Package Microsoft.EntityFrameworkCore.Tools

使用DB First

Scaffold-DbContext "Data Source=GoDaddy连线资料;Port=3306;Database=资料库名;Uid=帐号;Pwd=密" Pomelo.EntityFrameworkCore.MySql -OutputDir Models -UseDatabaseNames -Force

成功后

在Program.cs

var builder = WebApplication.CreateBuilder(args);

//MS SQL用
//builder.Services.AddDbContext<自订连线名>(options => options.UseSqlServer(builder.Configuration.GetConnectionString("自订连线名")));

//MySql用
builder.Services.AddDbContext<自订连线名>(options =>
{
   options.UseMySql(builder.Configuration.GetConnectionString("自订连线名") ?? throw new InvalidOperationException("Connection string '自订连线名' not found."),
   ServerVersion.AutoDetect(builder.Configuration.GetConnectionString("自订连线名")));
   options.EnableSensitiveDataLogging(true);  // 启用敏感数据日志
   options.LogTo(Console.WriteLine, LogLevel.Information);  // 将日志输出到控制台
});

appsettings.json

{
 "Logging": {
   "LogLevel": {
     "Default": "Information",
     "Microsoft.AspNetCore": "Warning"
   }
 },
 "AllowedHosts": "*",
 "ConnectionStrings": {
   "acprando_dbContext": "Data Source=GoDaddy连线资料;Port=3306;Database=资料库名;Uid=帐号;Pwd=密码"
  }
 }

在HomeController.cs测试

       private readonly ILogger<HomeController> _logger;
       private readonly 自订连线名 _自订连线名;

       public HomeController(ILogger<HomeController> logger, acprando_dbContext acprado_dbContext)
       {
           _logger = logger;
           _自订连线名 =自订连线名;
       }

       //public IActionResult Index()
       //{
       //    return View();
       //}

       public string? Index()
       {
           return _自订连线名.Table名.FirstOrDefault()?.栏位名称;

       }