ASP.NET MVC中按条件切换DbContext遇空引用异常的解决方案求助

我的实现步骤 #

1. 注册DbContext

builder.Services.AddDbContext<Context1>(options => options.UseMySql(conection1, ServerVersion.AutoDetect(conection1)));
builder.Services.AddDbContext<Context2>(options => options.UseMySql(conection2, ServerVersion.AutoDetect(conection2)));
builder.Services.AddDbContext<Context3>(options => options.UseMySql(conection3, ServerVersion.AutoDetect(conection3)));
// 更多DbContext注册

2. 定义DbContext继承结构
   所有DbContext都继承自Context0，包含相同的DbSet：

// Context0基类定义
namespace Project.Models
{
    public class Context0 : DbContext 
    {
        public Context0(DbContextOptions options): base(options)
        {
        }

        public DbSet<Table1> Table1 { get; set; }
        public DbSet<Table2> Table2 { get; set; }
        // 其他DbSet
    }
}

// Context1示例（Context2、Context3结构类似）
namespace Project.Models
{
    public class Context1 : Context0 
    {
        public Context1(DbContextOptions<Context0> options): base(options)
        {
        }

        public DbSet<Table1> Table1 { get; set; }
        public DbSet<Table2> Table2 { get; set; }
        // 其他DbSet
    }
}

3. 控制器中注入并动态选择

namespace Project.Controllers
{
    public class HomeController : Controller
    {
        private Context0 MainContext;
        private readonly Context1 InjectedContext1;
        private readonly Context2 InjectedContext2;
        private readonly Context3 InjectedContext3;
        // 更多注入的DbContext

        public HomeController(Context1 context1,
                              Context2 context2,
                              Context3 context3,
                              // 更多参数
                              )
        {
            InjectedContext1 = context1;
            InjectedContext2 = context2;
            InjectedContext3 = context3;
            // 赋值其他注入的DbContext

            // 根据条件选择MainContext
            if (some condition)
            {
                MainContext = InjectedContext2; 
            }
        }
    }
}

遇到的问题 #

调用MainContext.Table1.ToList()时抛出System.ArgumentNullException，提示MainContext为null，但确认：

• 构造函数中已将InjectedContext2正确赋值给MainContext；
• 直接调用InjectedContext2.Table1.ToList()可正常运行。
  怀疑MainContext的生命周期无法在控制器中维持，寻求解决办法。

解决方案 #

1. 修正MainContext的声明为只读（推荐） #

将private Context0 MainContext;改为private readonly Context0 MainContext;，并在构造函数中直接完成初始化，避免后续被意外覆盖或重置：

namespace Project.Controllers
{
    public class HomeController : Controller
    {
        private readonly Context0 MainContext;
        private readonly Context1 InjectedContext1;
        private readonly Context2 InjectedContext2;
        private readonly Context3 InjectedContext3;

        public HomeController(Context1 context1, Context2 context2, Context3 context3)
        {
            InjectedContext1 = context1;
            InjectedContext2 = context2;
            InjectedContext3 = context3;

            // 直接在构造函数赋值给只读字段，覆盖所有条件分支
            MainContext = some condition 
                ? InjectedContext2 
                : another condition ? InjectedContext3 : InjectedContext1;
        }
    }
}

务必覆盖所有条件分支，保证MainContext不会出现null的情况。

2. 使用工厂模式动态获取DbContext（更优雅的方案） #

如果条件判断依赖请求上下文（比如当前用户角色、请求参数），构造函数中无法获取这些信息，建议使用工厂模式：

步骤1：创建DbContext工厂

public interface IDbContextFactory
{
    Context0 GetContext();
}

public class DbContextFactory : IDbContextFactory
{
    private readonly Context1 _context1;
    private readonly Context2 _context2;
    private readonly Context3 _context3;
    private readonly IHttpContextAccessor _httpContextAccessor;

    public DbContextFactory(Context1 context1, Context2 context2, Context3 context3, IHttpContextAccessor httpContextAccessor)
    {
        _context1 = context1;
        _context2 = context2;
        _context3 = context3;
        _httpContextAccessor = httpContextAccessor;
    }

    public Context0 GetContext()
    {
        // 基于请求上下文判断条件，示例：根据请求参数选择
        var dbFlag = _httpContextAccessor.HttpContext.Request.Query["db"].ToString();
        return dbFlag switch
        {
            "db2" => _context2,
            "db3" => _context3,
            _ => _context1
        };
    }
}

步骤2：注册工厂和IHttpContextAccessor

builder.Services.AddHttpContextAccessor();
builder.Services.AddScoped<IDbContextFactory, DbContextFactory>();

步骤3：控制器中注入工厂

public class HomeController : Controller
{
    private readonly IDbContextFactory _dbContextFactory;

    public HomeController(IDbContextFactory dbContextFactory)
    {
        _dbContextFactory = dbContextFactory;
    }

    public IActionResult Index()
    {
        var mainContext = _dbContextFactory.GetContext();
        var data = mainContext.Table1.ToList();
        return View(data);
    }
}

3. 检查DbContext的生命周期配置 #

默认AddDbContext注册的是Scoped生命周期（与请求同生命周期），如果条件判断涉及跨请求的状态，需确保不会出现DbContext被提前释放的情况。绝对不要将DbContext注册为Singleton，否则会引发并发访问的严重问题。

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