Inject EntityFramework DbContext in a .NET 6 Azure Function

Bernhard 111

Where do I have to put the DbContext in a .NET 6 Azure Function?

builder.Services.AddDbContext

Bernhard 111

I created a new file Startup.cs and overwrote the Configure method:


using Microsoft.Azure.Functions.Extensions.DependencyInjection;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Configuration;
using Api.Data;

[assembly: FunctionsStartup(typeof(Api.Startup))]

namespace Api
{
    internal class Startup : FunctionsStartup
    {
        public override void Configure(IFunctionsHostBuilder builder)
        {
            builder.Services.AddDbContext<DataContext>(options =>
                options.UseSqlServer("Data Source=CONNECTIONSTRINGREMOVED"));
        }
    }
}

After starting I received that error:

User's image

Could not load file or assembly 'Microsoft.Extensions.Logging.Abstractions, Version=7.0.0.0, Culture=neutral, PublicKeyToken=adb9793829ddae60'.

I added the nuget package Microsoft.Extensions.Logging.Abstractions and added a global using in the Startup.cs global using Microsoft.Extensions.Logging.Abstractions; but the error persists.

Bernhard 111 Reputation points

2023-01-21T13:56:26.1033333+00:00

Test comment because my comment disappeared

1 answer

Bruce (SqlWork.com) 65,211 Reputation points

2023-01-22T19:55:20.4733333+00:00

you need to add the nuget package:

Microsoft.Extensions.Logging.Abstractions

note: it should have been added when you added:

Microsoft.Extensions.Configuration
Please sign in to rate this answer.
Bernhard 111 Reputation points

2023-01-25T11:56:46.0033333+00:00

My last comment disappeared after the posting, but it is there now. As you can see I already did that, but it does still not work. Thanks for your note Bruce, I will re-add the packaged. Maybe this does help.

Bernhard 111 Reputation points

2023-01-28T22:05:22.9266667+00:00

I've uninstalled both packages now, and installed the Microsoft.Extensions.Configuration again. As you wrote the Abstractions it depends on the Abstractions package, but when I installed the Configuration package nothing comes with it. Another interesting thing is that:

But the 2.1.0 package did not exist in the project:

But I found the culprit. The Azure function project delivered the Microsoft.Extensions.Configuration version 2.1.0. But the EF 7.0.2 requires the Microsoft.Extensions.Logging.Abstractions version 7.0.0, which is not compatible with the Microsoft.Extensions.Configuration version 2.1.0

After downgrading the EF packages to 6.0.2 everything works.

JV 0 Reputation points

2024-03-18T13:24:34.16+00:00

May I know how you were able to pinpoint "The Azure function project delivered the Microsoft.Extensions.Configuration version 2.1.0. But the EF 7.0.2 requires the Microsoft.Extensions.Logging.Abstractions version 7.0.0, which is not compatible with the Microsoft.Extensions.Configuration version 2.1.0" ?
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Inject EntityFramework DbContext in a .NET 6 Azure Function

1 answer

Your answer