Reader close issue

Question

I am using asp.net with web api. In my project there is a message page which is accessible to all guests. This message page will get automatically refreshed for all guests using signalR if there is message for all guests.

But some of the guests are getting an error on the message page as all guest pages are refreshing at the same time. so in code behind same function(which is responsible for getting the messages from database) is called simultaneously some message for some guest retrieved properly but for some other guests reader is getting closed before retrieving the messages.

could you also add some code? – Florin Secal Jun 25 '16 at 15:39 — Florin Secal, Jun 25 '16 at 15:39

score 0 · Answer 1 · edited May 23 '17 at 10:28

Reason for the issue:

Due to the use of "application.Application.Add(requestUrl, clientDatabase)" This was adding the database in application variable there for same database connection is used throughout the application scope. So while doing some simultaneous requests to database same connection was used and any of the request causes the connection to be closed resulted in error for other request which were in the middle of execution.

eg Send message to all guest causes all guests message window to be refreshed. In refreshing we are fetching the messages from database for all the guest. so there were simultaneous requests if any one completes the message fetching then it closes the connection since the same connection was being used by other requests too, other requests gets the error

Resolution:

Rather than adding the database in "application.Application.Add(requestUrl, clientDatabase)" we will add in the "application.Context.Items.Add(requestUrl, clientDatabase)". This makes the database persist for the single HTTP request only.