.Net EntityFrameworkCore问题汇总

从.Net7升级.Net8失败总结： 1、添加MySql:

static void AddMySql(WebApplicationBuilder builder)
{
    // Add Sql
    var mySqlConnection = builder.Configuration.GetConnectionString("MySqlConnection");
    builder.Services.AddDbContext<SsnDbContext>(options =>
           {
               options.UseMySQL(mySqlConnection, mySqlOptionsAction: sqlOptions =>
               {
                   sqlOptions.MigrationsAssembly(typeof(SsnDbContext).GetTypeInfo().Assembly.GetName().Name);
                   sqlOptions.CommandTimeout(300);
               });

               //
               options.UseLoggerFactory(LoggerFactory.Create(o => o.SetMinimumLevel(LogLevel.Information)));
               options.EnableSensitiveDataLogging();

           });
}

2、添加引用 Microsoft.EntityFrameworkCore.Design(不能使用.Net8)

3、添加DbContext

    public class SsnDbContext : DbContext
    {
        public SsnDbContext(DbContextOptions<SsnDbContext> options) : base(options) { }

        protected override void OnModelCreating(ModelBuilder modelBuilder) { }

        #region DbSet

        public DbSet<DeviceFdma> DeviceFdma { get; set; }

        #endregion

    }