Inject EntityFramework DbContext in a .NET 6 Azure Function

Question

Inject EntityFramework DbContext in a .NET 6 Azure Function

Bernhard S 126

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

builder.Services.AddDbContext

Bernhard S 126

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 S 126 Reputation points

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

Test comment because my comment disappeared

1 answer

Your answer

Bernhard S 126 Reputation points

2023-01-21T13:29:26.0866667+00:00

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:

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 S 126 Reputation points

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

Test comment because my comment disappeared

Answer 1

Bruce (SqlWork.com) 81,981 Volunteer Moderator

you need to add the nuget package:

Microsoft.Extensions.Logging.Abstractions

note: it should have been added when you added:

Microsoft.Extensions.Configuration

Bernhard S 126 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 S 126 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" ?

Share via

Inject EntityFramework DbContext in a .NET 6 Azure Function

1 answer

Your answer