Is using a singleton for the connection a good idea in ASP.NET website
Using a single connection is an extremely bad idea – if access to the connection is properly locked, it means that ASP.NET can only serve one user at a time, which will seriously limit your application’s ability to grow. If the connection is not properly locked, things can get really weird. For example, one thread … Read more