Azure app Service with entity framework System.NotSupportedException

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,

https://github.com/aspnet/EntityFramework6/issues/623

Please use Entity Framework core with your function app V2.

I believe this helps. Please share your query/feedback.