A foreign key violation error occurs in one page and the exception is shown in all the other pages for all the users
We have a asp.net MVC application and it uses Entity Framework. There was a bug in one of the pages where it causes foreign key violation error.
Problem is when someone gets that error, everybody else coming to the home page gets the same exception message. The app pool doesn't stop but recycling the app pool makes the home page available again. My question is why an exception by one users causes problem to everyone else.
We've fixed the foreign key issue now. But if there are other DB operation exception, same thing is happening.