Local Works. Azure Give Error: Invalid Object Name 'dbo.aspnetusers'. Why?

I am getting this error when I try to register a user etc: Invalid object name 'dbo.AspNetUsers'. Which gives me 2 questions: 1) How can I solve this problem 2) Why do I have thi

Solution 1:

OK. So the red-herring here is that other people have posted the same error such as these questions: - ASP.Net Identity - Use custom Schema - Invalid object name 'dbo.AspNetUsers' in Asp.NET MVC 5 Entity Framework - Invalid object name 'dbo.AspNetUsers'

But for me after trying all of the above I have tracked the issue to the Publish dialog in visual studio updating my connection string for me (to look at an old database). I found this after debugging what the connection string was on my Azure published website.

Solution 2:

I didn't migrate the database properly causing the same error when doing a POST request.

Solution 3:

if your application running good locally(iis) while throwing exception in azure, then you need to turn off application insights of your resource in azure.