Strong Coders Community

Hi,

I have one query which if some experienced persons can give reliable answer to it.Is it advisable to implement singleton pattern in ASP.NET for having single database connection object throughout the application?Will website become scalable if we implement singleton pattern for single database connection in asp.net? or using(connection conn) syntax is better approach?

I would be grateful if some experienced person can give reliable answer to it.

Thanks and Regards,

Manish Bafna.

MCP and MCTS.

 

On the whole, I don't see the advantage.  First of all, ASP.Net programs are very short-lived.  They are started; they create one page, and then they die.  So, what you are talking about is not so much a singleton, but a persistant object.  There are many pros & cons with persistance.  However, with database connections, pooling is built in, so there not much advantage in doing it yourself.

---

Truth,
James