I am using asp.net 4.0 for my application that connects to sql server 2008 via ADO.Net Entity Framework. When there is bit increase in traffic the site goes down. I notice below error in event management
Execution of the command requires an open and available connection. The connection's current state is broken.
I am developing application with Entity Framework for the first time, and its opening and closing connection by itself. What i think is the connection to data base needs to be opened and closed manually.
If i am rite kindly tell me how can i do it but if i am not what other thing might throw this exception.