Azure Functions隔离式.NET7中EF Core执行Add-Migration报错

常见遗漏配置项 #

• DbContext设计时实例化逻辑缺失
  EF Core迁移工具在设计时无法直接复用隔离式函数的DI配置，需补充设计时工厂或确保构造函数兼容：
  添加IDesignTimeDbContextFactory实现：

  using Microsoft.EntityFrameworkCore;
  using Microsoft.EntityFrameworkCore.Design;
  using Microsoft.Extensions.Configuration;
  using System.IO;
  
  public class MyDbContextFactory : IDesignTimeDbContextFactory<MyDbContext>
  {
      public MyDbContext CreateDbContext(string[] args)
      {
          var config = new ConfigurationBuilder()
              .SetBasePath(Directory.GetCurrentDirectory())
              .AddJsonFile("local.settings.json")
              .Build();
  
          var options = new DbContextOptionsBuilder<MyDbContext>();
          options.UseSqlServer(config.GetConnectionString("YourConnStringKey"));
  
          return new MyDbContext(options.Options);
      }
  }
  

  同时确保MyDbContext存在接收DbContextOptions<MyDbContext>的构造函数：

  public class MyDbContext : DbContext
  {
      public MyDbContext(DbContextOptions<MyDbContext> options) : base(options) { }
      // DbSet定义...
  }
  

• local.settings.json连接字符串配置错误
  迁移工具读取项目根目录的local.settings.json，需确保ConnectionStrings节点存在且键名匹配代码：

  {
    "IsEncrypted": false,
    "Values": {
      "AzureWebJobsStorage": "UseDevelopmentStorage=true",
      "FUNCTIONS_WORKER_RUNTIME": "dotnet-isolated"
    },
    "ConnectionStrings": {
      "YourConnStringKey": "Server=.;Database=YourDbName;Trusted_Connection=True;TrustServerCertificate=True"
    }
  }
  

• 设计时工具包未安装
  必须安装Microsoft.EntityFrameworkCore.Design包，迁移工具依赖此包完成设计时操作：

  Install-Package Microsoft.EntityFrameworkCore.Design -Version 7.0.1
  

• 迁移命令未指定项目/上下文
  若解决方案包含多个项目，需明确指定目标项目和上下文类：

  Add-Migration InitialCreate -Project YourFunctionsProject -Context MyDbContext
  

• Program.cs服务注册不完整
  确保隔离式函数的Host构建中正确注册DbContext：

  var host = new HostBuilder()
      .ConfigureFunctionsWorkerDefaults()
      .ConfigureServices(services =>
      {
          services.AddDbContext<MyDbContext>(options =>
              options.UseSqlServer(Environment.GetEnvironmentVariable("ConnectionStrings:YourConnStringKey")));
      })
      .Build();
  
  host.Run();
  

内容的提问来源于stack exchange，提问作者Trần Như Tuấn Anh