无法创建ApplicationDbContext实例，EF Core迁移失败求助

你的问题核心在于：EF Core迁移工具无法自动解析ApplicationDbContext构造函数中的IDateTimeService和IAuthenticatedUserService依赖——迁移工具运行时并未接入你的应用依赖注入容器，所以无法实例化这些服务。

下面是两种可靠的解决方案：

方案一：添加设计时专用构造函数 #

在ApplicationDbContext中添加一个仅接收DbContextOptions<ApplicationDbContext>参数的构造函数，供迁移工具使用，同时保留原有构造函数供应用运行时使用：

public class ApplicationDbContext : IdentityDbContext<ApplicationUser>
{
    private readonly IDateTimeService _dateTime;
    private readonly IAuthenticatedUserService _authenticatedUser;

    // 应用运行时使用的构造函数
    public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options, IDateTimeService dateTime, IAuthenticatedUserService authenticatedUser) : base(options)
    {
        ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
        _dateTime = dateTime;
        _authenticatedUser = authenticatedUser;
    }

    // 迁移工具专用的设计时构造函数
    public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options)
    {
        ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
        // 迁移时不需要真实服务，使用模拟实现
        _dateTime = new MockDateTimeService();
        _authenticatedUser = new MockAuthenticatedUserService();
    }

    public DbSet<Quiz> Quizzes { get; set; }

    // 原有SaveChangesAsync方法调整，兼容空依赖场景
    public override Task<int> SaveChangesAsync(CancellationToken cancellationToken = new CancellationToken())
    {
        foreach (var entry in ChangeTracker.Entries<AuditableBaseEntity>())
        {
            switch (entry.State)
            {
                case EntityState.Added:
                    entry.Entity.Created = _dateTime?.NowUtc ?? DateTime.UtcNow;
                    entry.Entity.CreatedBy = _authenticatedUser?.UserId ?? "MigrationUser";
                    break;
                case EntityState.Modified:
                    entry.Entity.LastModified = _dateTime?.NowUtc ?? DateTime.UtcNow;
                    entry.Entity.LastModifiedBy = _authenticatedUser?.UserId ?? "MigrationUser";
                    break;
            }
        }
        return base.SaveChangesAsync(cancellationToken);
    }
}

// 模拟服务实现（仅用于迁移场景）
public class MockDateTimeService : IDateTimeService
{
    public DateTime NowUtc => DateTime.UtcNow;
}

public class MockAuthenticatedUserService : IAuthenticatedUserService
{
    public string UserId => "MigrationUser";
}

添加完成后，重新运行迁移命令：

# Package Manager Console
Add-Migration InitialCreate

# .NET CLI
dotnet ef migrations add InitialCreate

方案二：实现IDesignTimeDbContextFactory接口 #

创建单独的工厂类负责设计时创建上下文实例，这种方式不会污染上下文类本身，更符合单一职责：

using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Design;
using Microsoft.Extensions.Configuration;
using System.IO;

public class ApplicationDbContextFactory : IDesignTimeDbContextFactory<ApplicationDbContext>
{
    public ApplicationDbContext CreateDbContext(string[] args)
    {
        // 加载应用配置，确保连接字符串和应用一致
        var configuration = new ConfigurationBuilder()
            .SetBasePath(Directory.GetCurrentDirectory())
            .AddJsonFile("appsettings.json")
            .Build();

        // 配置DbContext选项
        var optionsBuilder = new DbContextOptionsBuilder<ApplicationDbContext>();
        optionsBuilder.UseSqlServer(configuration.GetConnectionString("DefaultConnection"));

        // 传入模拟服务创建上下文
        return new ApplicationDbContext(
            optionsBuilder.Options,
            new MockDateTimeService(),
            new MockAuthenticatedUserService()
        );
    }
}

// 模拟服务实现（同方案一）
public class MockDateTimeService : IDateTimeService
{
    public DateTime NowUtc => DateTime.UtcNow;
}

public class MockAuthenticatedUserService : IAuthenticatedUserService
{
    public string UserId => "MigrationUser";
}

完成后直接运行迁移命令即可，EF工具会自动识别并使用这个工厂类创建上下文实例。

内容的提问来源于stack exchange，提问作者Mert Batuhan ÜNVERDİ