Should we use singleton pattern for connection creation or not?
===

I’ve seen some people says it is OK to use singleton pattern to the Data Access Layer to create Connections. Others says we should not use singleton pattern. The arguments given by both parties are valid for some extend, but from software engineering point of view what is correct. For an example for a Web Application should we use singleton pattern to the Data Access Layer. 

Thanks. 
