I am trying to make a simple Web API with Azure Functions (Http trigger).
In my function I want to access a SQL Server Database.
I would like to retrieve my data from the database using Entity Framework Core.
I would prefer to to use the newest versions available at the time of posting this:
- Entity Framework Core 3.1.0
- Azure Functions v3 (.NET Core)
I have an existing database, therefor I want to do reverse engineering using the Scaffold-DbContext command.
In order to do this I have added the following packages to my Azure Functions v3 project created in Visual Studio:
- Microsoft.EntityFrameworkCore.SqlServer (3.1.0)
- Microsoft.EntityFrameworkCore.Tools (3.1.0)
When running the Scaffold-DbContext command in the Package Manager Console I get the following error: