在.NET 6 Azure Function中添加Entity Framework遇依赖注入解析失败

我正在.NET 6.0的Azure Function项目中集成Entity Framework，运行函数时出现以下错误：

"Microsoft.Extensions.DependencyInjection.Abstractions: 尝试激活 'Function1' 时，无法解析类型 'FDBContext' 的服务。"

使用的NuGet包：

Microsoft.Azure.Functions.Extensions v1.1.0
Microsoft.EntityFrameworkCore.Relational v7.0.5
Microsoft.EntityFrameworkCore.SqlServer v7.0.5
System.Data.SqlClient  v4.8.5

代码文件 #

Startup.cs #

class Startup : FunctionsStartup
{
    public override void Configure(IFunctionsHostBuilder builder)
    {
        builder.Services.AddDbContext<FDBContext>(options =>
        {
            options.UseSqlServer("<可用的连接字符串>");
        });
        builder.Services.AddOptions();
    }
}

FDBContext.cs #

public class FDBContext : DbContext
{
    public FDBContext(DbContextOptions<FDBContext> context) : base(context)
    {  }

    public DbSet<DBData> DBDatas { get; set; }
}

Function1.cs #

public class Function1
{
    private readonly FDBContext _context;
    public Function1(FDBContext context)
    {
        _context = context;
    }

    [FunctionName("Function1")]
    public async Task<IActionResult> Run(
        [HttpTrigger(AuthorizationLevel.Function, "get", "post", Route = null)] HttpRequest req)
    {
        var test = _context.DBDatas.ToList();
    }
}

错误日志 #

[2023-05-15T19:33:34.607Z] 实例 ID '0000000000000000000000008A575D25' 已获取主机锁租约。
[2023-05-15T19:33:44.495Z] 正在执行 HTTP 请求：{
[2023-05-15T19:33:44.497Z]   requestId: "53766d70-997b-4fda-a58b-bdae741fd544",
[2023-05-15T19:33:44.498Z]   method: "POST",
[2023-05-15T19:33:44.499Z]   userAgent: "PostmanRuntime/7.26.8",
[2023-05-15T19:33:44.500Z]   uri: "/api/Function1"
[2023-05-15T19:33:44.501Z] }
[2023-05-15T19:33:44.808Z] 已执行 'Function1' (失败, Id=9181b193-7127-4484-80b3-8ec98d77066e, 时长=39ms)
[2023-05-15T19:33:44.809Z] Microsoft.Extensions.DependencyInjection.Abstractions: 尝试激活 'FunctionApp2.Function1' 时，无法解析类型 'FiedlDeviceFunctionApp2.FDBContext' 的服务。
[2023-05-15T19:33:44.816Z] 发生未处理的主机错误。
[2023-05-15T19:33:44.817Z] Microsoft.Extensions.DependencyInjection.Abstractions: 尝试激活 'FunctionApp2.Function1' 时，无法解析类型 'FiedlDeviceFunctionApp2.FDBContext' 的服务。
[2023-05-15T19:33:44.822Z] 已执行 HTTP 请求：{
[2023-05-15T19:33:44.823Z]   requestId: "53766d70-997b-4fda-a58b-bdae741fd544",
[2023-05-15T19:33:44.823Z]   identities: "(WebJobsAuthLevel:Admin)",
[2023-05-15T19:33:44.825Z]   status: "500",
[2023-05-15T19:33:44.826Z]   duration: "325"
[2023-05-15T19:33:44.830Z] }

问题排查与解决步骤 #

1. 强制指定Startup类加载 #

Azure Functions不会自动识别Startup类，必须添加程序集特性标记。修改Startup.cs：

using Microsoft.Azure.Functions.Extensions.DependencyInjection;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.DependencyInjection;

// 替换成你的项目实际命名空间
[assembly: FunctionsStartup(typeof(YourNamespace.Startup))]
namespace YourNamespace
{
    class Startup : FunctionsStartup
    {
        public override void Configure(IFunctionsHostBuilder builder)
        {
            builder.Services.AddDbContext<FDBContext>(options =>
            {
                options.UseSqlServer("<可用的连接字符串>");
            });
            builder.Services.AddOptions();
        }
    }
}

2. 统一命名空间 #

从错误日志可见，FDBContext和Function1分属不同命名空间（FiedlDeviceFunctionApp2 vs FunctionApp2），导致DI容器无法匹配服务。确保FDBContext、Startup、Function1处于同一个命名空间，或在Startup中正确引用FDBContext的命名空间。

3. 验证DbContext生命周期 #

显式指定Scoped生命周期（符合Azure Functions请求生命周期）：

builder.Services.AddDbContext<FDBContext>(options =>
    options.UseSqlServer("<可用的连接字符串>"),
    ServiceLifetime.Scoped);

4. 对齐包版本兼容性 #

当前EF Core 7.0.5与.NET 6环境存在版本适配风险，建议降级到.NET 6兼容的EF Core 6.x系列：

Microsoft.EntityFrameworkCore.Relational v6.0.25
Microsoft.EntityFrameworkCore.SqlServer v6.0.25

5. 补充函数返回逻辑 #

Function1的Run方法缺少返回语句，会导致编译错误，补充：

public async Task<IActionResult> Run(
    [HttpTrigger(AuthorizationLevel.Function, "get", "post", Route = null)] HttpRequest req)
{
    var test = _context.DBDatas.ToList();
    return new OkObjectResult(test);
}

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