Entity Framework Core - Knowledge Base (KB)
21 results in tag: azure-functions
Can't load Entity Framework Core in Azure Function
I'm trying to use Entity Framework Core with a C# Azure Function, and I'm getting tons of errors with libraries. Starting from the default HTTP trigger template, I created a ...project.json... file containing...{ "frameworks": { "net46":{ "dep...
asked by 0xFE
Azure functions with Entity Framework Core 2.0 and .NET 4.7
I am running into issues running Entity Framework queries from within an Azure Function. The same code runs perfectly fine from a Console Application....Here is the exact error I am getting: ..."Could not load file or assembly 'System.ValueTuple, Versio...
asked by Anup Marwadi
EF Core 2.0 connection string in Azure Functions .NET Core
I'm using EF core 2.0 in Azure Functions using .net core. I'm trying to read db ConnectionString from local.settings.json, which is defined:...{ "IsEncrypted": false, "Values": { "AzureWebJobsStorage": "UseDevelopmentStorage=true", "AzureWebJo...
asked by Boris Lipschitz
Azure Functions 1.0.7 giving Could not load file or assembly error with EF Core 2
I'm trying to move some functionality to Azure Functions. Created a project for EF Core 2 code, and referenced it to the Azure Functions project. Added the EF Core+SQLServer nugget packages to the Azure Functions project. When the function attempts to exe...
asked by John C
Unable to load Entity Framework Core into C# azure function
I already opened an ...issue... in ...Azure/azure-functions-host... and I have a ...repo... with the repro steps, but I'm posting this here in case there is something inherently wrong with what I'm doing, or someone has already stumbled open this issue...
asked by Maximo Dominguez
Azure Function, EF Core, Can't load ComponentModel.Annotations 4.2.0.0
I have created several .Net Standard 2.0 libraries, tested the execution via a console application, as well as several tests - all is good....Move over to azure function, and get the following run-time error: ...I then try to download that specific versio...
asked by codeputer
Groupby evaulating locally for Entity Framework Core 2.1.4 inside Azure Function version 2
Microsoft says that the Entity Framework Core 2.1 generates a ...GROUPBY... statement to the server. I have an Azure Function using the Entity Framework Core 2.1.4 but still got:...Microsoft.EntityFrameworkCore.Query:Warning: The LINQ expression 'Sum()' c...
asked by Justin Curious
Getting transient errors when making calls against Azure SQL Database from Azure Function
We are using .NET Core 2.1 and Entity Framework Core 2.1.1...I have the following setup in Azure West Europe...Azure SQL Database -- Premium P2 250 DTU -- Public endpoint, no VNET peering -- "Allow access to Azure Services" = ON...Azure Functions -- Consu...
asked by VSorokoumov
System.Private.CoreLib: Exception while executing function: System.Data.SqlClient: Keyword not supported: 'authentication'
I am writing a function to log information from every file uploaded to a blob storage account using entity framework core. When I try to connect to the azure sql db, I get the following error: ...System.Private.CoreLib: Exception while executing function:...
asked by Bishop
Microsoft.Azure.WebJobs.Host: Cannot bind parameter 'myContext' to type DataContext. error in Azure Function v2
Requirement: Create Azure Function which can inject ...Entity Framework... context to ...Run... method using dependency injection....Here is my ...Startup... class... [assembly: WebJobsStartup(typeof(Startup))] namespace MessagesToSqlDbFuncApp {...
asked by kudlatiger
Entity framework resiliency and retry logic
I get a lot of errors when adding data to my Azure SQL server like this:...An exception has been raised that is likely due to a transient failure. If you are connecting to a SQL Azure database consider using...I can see on following link you can impleme...
asked by Thomas Segato
Azure Function Queue triggered with Mediatr - DbContext error
I'm implementing Queue triggered azure function - I'm using a Mediator Pattern library called Mediatr for enhancing command query segregation - and using the latest run-time (2.0.12382.0) constructor dependency injection in Azure Function according to the...
asked by Joseph Wasily
Dependency Inject ClaimsPrincipal into DbContext when using EasyAuth in Azure Functions 2.0
Using Azure Functions 2.0 with EasyAuth (Azure one click option to enable authentication against azure ad)....This allows me to get given a ClaimsPrincipal in the function definition...public async Task<IActionResult> Run([HttpTrigger(AuthorizationLevel.A...
asked by Betty
Cannot access a disposed object when injecting DbContext through Azure Function
I am receiving the following error when trying to inject the DbContext into an Azure Function:...Microsoft.EntityFrameworkCore: Cannot access a disposed object. ...Here is the current function... private readonly FundCentreContext _fundCentreContext; ...
asked by ZephyrAxis
Azure Function Uses Wrong DbContext Constructor
I have an existing EF Core 2.2 ...DbContext... that works fine in an ASPNET Core application as well as LinqPad. Now I am trying to add it to an Azure function. In both ASPNET and the Azure function I am using dependency injection....The ...DbContext...
asked by Mark Wagoner
EF Core connection string settings with azure functions and web api
I have 2 projects 1.ASP.NET Core WEB API 2. Azure function...Both are hosted on a azure. I also have different accounts for development and production, hense I need to have different connection strings depending on environment the application are deployed...
asked by amplifier
An assembly specified in the application dependencies manifest (<my-project>.deps.json) was not found
When I run:...dotnet ef migrations add InitialCreate ...It errors:...Error: An assembly specified in the application dependencies manifest (idb-dialog-flow.deps.json) was not found: package: 'idb-dialog-flow', version: '1.0.0' path: 'idb-d...
asked by AskYous
Can you use v3 Azure Functions with Entity Framework Core 3.0?
I am trying to use EF Core 3 in the latest (preview) version of Azure functions, but I am getting the following error when I try interacting with the database:...System.Private.CoreLib: Exception while executing function: DemoFunction. Microsoft.Data.SqlC...
asked by Ben
How do I use Entity Framework Core in Azure Functions
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 v...
asked by Stephan Smit
azure functions unable to scaffold dbcontext
Using VS 2019, .net core 2.1 and 3.1 I tried to create a map of existing db....I executed the following npm commands...Install-Package Microsoft.EntityFrameworkCore.SqlServer -Version 3.1.1 Install-Package Microsoft.EntityFrameworkCore.Tools -Version 3.1....
asked by jay
Page 1 of 2