title: Pros and Cons of using Singleton Pattern in DAL
body: <p>I have asked to use singleton pattern implemented DAL, but I think its difficult to pool the connections,use transactions..etc</p>
  
  <p>I would like to know the pros and cons and also would like to know the best way to pool the connections as there can be more than 500 concurrent users for the site I am developing.</p>
  
  <p>DB Server is Oracle 10g.</p>
  
  <p>DAL uses Enterprise library 3.1</p>