Azure app Service with entity framework System.NotSupportedException
Issue:
· System.NotSupportedException: Unable to determine the provider name for provider factory of type 'System.Data.SqlClient.SqlClientFactory'. Make sure that the ADO.NET provider is installed or registered in the application config?
Solution:
If you are facing this exception, then chances are you are using function app V2(.Net core) with Entity Framework 6.
This happened in my case and I observed that Function App V2(.Net core) is not supported with Entity Framework 6.
If you create a function in V1 with Entity Framework 6 then you will not face this issue. I Created a sample function app (http trigger) with V1 and EF6 which worked fine.
You can get more information in below URL,
Please use Entity Framework core with your function app V2.
I believe this helps. Please share your query/feedback.
