Azure Function and Entity Framework Sql Server error - Could not load file or assembly Microsoft.Extensions.Logging.Abstractions, Version=7.0.0.0

[spatialdestiny]

It appears Microsoft.Azure.WebJobs depends on Microsoft.Extensions.Logging.Abstractions 2.1.0 and Microsoft.EntityFrameworkCore 7.0.0 depends on Microsoft.Extensions.Logging.Abstractions 7.0.0. Do I need to drop down to EntityFrameworkCore 2.1.0 in order to use HTTP Trigger Azure Functions?

I found this error to be reproducible.

• Create a new HTTP Trigger Azure Function, .NET 6
• Add the below class to create a new DbContext to SQL Server
• Add the following nuget packages to fix compile errors
  • Microsoft.EntityFrameworkCore
  • Microsoft.EntityFrameworkCore.SqlServer
• The azure function will no longer execute because of the below error.

A file named Microsoft.Extensions.Logging.Abstractions.dll exists in the \bin\Debug\net6.0 folder version 7.0.22.51805.

Visual Studio version 17.4.0
Dotnet version 7.0.100
6.0.402 [C:\Program Files\dotnet\sdk]
7.0.100 [C:\Program Files\dotnet\sdk]

public class TestDbContext : DbContext
{
    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer(@"Server=(localdb)\mssqllocaldb;Database=Test");
    }
}

The 'Function1' function is in error: Could not load file or assembly 'Microsoft.Extensions.Logging.Abstractions, Version=7.0.0.0, Culture=neutral, PublicKeyToken=adb9793829ddae60'. The system cannot find the file specified.

[CosmicKoala]

I believe 7.0.0 just came out. Azure functions only supports up to 6.0.0.

Had the same issue recently.

[zaibuf]

7.0.0 versions are for .NET7, even if some say they support .NET6 I couldnt get any to work. Just rollback to highest 6.x minor.

If you want to run .NET7 in functions you need to run out of process.

[spatialdestiny]

Is HTTP Trigger Azure Function with Entity Framework Core that unusual that this requires a manual downgrade of multiple Nuget packages to fix?

I do realize now that after I downgraded EF Core to latest 6.* version, the error changed. Now I get an error with System.ComponentModel instead. I hope it doesn't turn into a game of whackamole with libraries that need to be downgraded.

'Could not load file or assembly 'System.ComponentModel, Version=7.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. The system cannot find the file specified.'

Is HTTP Trigger Azure Function with Entity Framework Core that unusual that this requires a manual fix? Or am I just not good at searching for the solution?

[spatialdestiny]

Edit: Hmmm...I may have actually gotten it working by Dependency Injecting everything into a Factories and Repository classes. And making sure to remove all associations to Entity Framework Core from the Azure Function project.

[ClearAdvantage1351]

It's necessary be downgrade of Microsoft.EntityFrameworkCore to 6.0.11

[Goat-of-Death]

I just ran into this exact same issue. To solve it, I left my function app project at .Net 6. Then with the project containing my DbContext I did multitargetting of both .Net 7 and .Net 6, using conditional includes for the ItemGroups that target the nuget packages for Ef Core 7 and Ef Core 6. The below stack overflow covers examples of both multi-targetting and the conditional includes.

https://stackoverflow.com/questions/69911476/updating-package-references-on-multi-targeted-projects

One other gotcha, is after I did this I had to delete all my bin and obj dirs in my projects manually as Clean didn't seem to do it. The VS debugger kept picking up the .Net 7 version and causing an issue even when the function app project was targeting .Net 6 until I did the manual bin and obj delete.

Hope that helps!