My web site is on MVC5 + EntityFramework 6 code first. When running localy it works fine. But after deployment (as Azure website and Azure SQL DB) it has materialization errors like this. On different pages there are different errors, but all of them is about materialization.
What we tried to solve this problem:
- Increased database timeout from 30 to 120 like suggested here Entity Framework “Invalid attempt to read when no data is present” with 'large' data on Azure . This did not help.
- Connected to Azure DB from local web site instance in debug mode, but did not catch any errors.
- Then we created one Azure resource group and placed both web site and DB in that group (At first time web site was in other group). And it looks like error is not apear any more.
So we found some workaround but did not fix error. And there is no garanties that this exceptions will never apear again. Did somebody faced such errors?