Identity用户与TaskData多对多配置后迁移报错：无法创建IdentityContext

我尝试在Identity用户（ApplicationUser）和TaskData表之间建立多对多关联，修改IdentityContext后创建EF Core迁移时，遇到错误：无法创建类型为'IdentityContext'的DbContext，激活'DataloaderApi.IdentityContext'时无法解析'Microsoft.EntityFrameworkCore.DbContextOptions`1[DataloaderApi.IdentityContext]'服务。

相关代码 #

IdentityContext代码 #

using Microsoft.AspNetCore.Identity.EntityFrameworkCore;
using Microsoft.AspNetCore.Identity;
using Microsoft.EntityFrameworkCore;
using DataloaderApi.Data;

namespace DataloaderApi
{
    public class IdentityContext: IdentityDbContext<ApplicationUser>
    {
        public DbSet<TaskData> TaskData { get; set; }
       
        public IdentityContext(DbContextOptions<IdentityContext> options) : base(options)
        {
        }

        protected override void OnModelCreating(ModelBuilder builder)
        {
            base.OnModelCreating(builder);

            // 配置多对多关系
            builder.Entity<TaskData>()
                .HasMany(t => t.AssignedUsers)
                .WithMany(u => u.Tasks)
                .UsingEntity(j => j.ToTable("TaskDataUserJunction"));
        }
    }
}

ApplicationUser代码 #

namespace DataloaderApi.Data
{
    public class ApplicationUser:IdentityUser
    {
        public ICollection<TaskData> Tasks { get; set; }
    }
}

TaskData代码 #

using Microsoft.AspNetCore.Identity;

namespace DataloaderApi.Data
{
    public class TaskData
    {
        public long Id { get; set; }
        public string TaskName { get; set; }
        public string TaskDescription { get; set; }
        public string sourceLocation { get; set; }
        public string DestinationTable { get; set; }
        public bool isActive { get; set; }
        public ICollection<ApplicationUser> AssignedUsers { get; set; }
    }
}

Program.cs核心代码 #

var connectionString = builder.Configuration.GetConnectionString("dataloaderConnection");

builder.Services.AddDbContext<IdentityContext>(options =>
    options.UseSqlServer(connectionString));

builder.Services.AddIdentityApiEndpoints<ApplicationUser>()
 .AddRoles<IdentityRole>()
.AddEntityFrameworkStores<IdentityContext>();

解决方案 #

这个错误是EF Core在设计时无法获取IdentityContext的配置选项导致的，可通过以下方式解决：

1. 实现IDesignTimeDbContextFactory接口 #

在项目中添加一个工厂类，让EF Core迁移工具能在设计时正确加载配置并创建上下文：

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

namespace DataloaderApi
{
    public class IdentityContextFactory : IDesignTimeDbContextFactory<IdentityContext>
    {
        public IdentityContext CreateDbContext(string[] args)
        {
            var configuration = new ConfigurationBuilder()
                .SetBasePath(Directory.GetCurrentDirectory())
                .AddJsonFile("appsettings.json")
                .Build();

            var optionsBuilder = new DbContextOptionsBuilder<IdentityContext>();
            optionsBuilder.UseSqlServer(configuration.GetConnectionString("dataloaderConnection"));

            return new IdentityContext(optionsBuilder.Options);
        }
    }
}

2. 指定启动项目执行迁移 #

如果DbContext项目与启动项目分离，执行迁移命令时明确指定启动项目：

dotnet ef migrations add AddTaskUserManyToMany --startup-project 你的启动项目路径

3. 验证配置与服务注册 #

• 确认appsettings.json中存在dataloaderConnection连接字符串，并且格式正确
• 检查Program.cs中IdentityContext的注册代码无遗漏，确保连接字符串被正确注入

内容的提问来源于stack exchange，提问作者Virgil