getting db connection through singleton class

by

Your Singleton is still off.

As far as the singleton pattern goes, please see Jon Skeet’s very good and detailed description here : http://www.yoda.arachsys.com/csharp/singleton.html

Using a Singleton for a SqlConnection object is a really, really bad idea. There is no reason to do this whatsoever.

If you are attempting to avoid a performance hit of “new SqlConnection()” or “connection.Open()” be advised that there really is no performance hit there because of the connection pooling going on behind the scenes. Connection Pooling handles the opening/closing of the expensive connections. Not the SqlConnection object.

You won’t be able to open multiple SqlDataReaders/Commands with the connection at the same time and will run into thread blocking issues if you are trying to share the same connection object with multiple threads.

The Singleton pattern is the most over used and abused pattern and there are many side effects of the singleton that you may not be aware of. Very good talk about the dangers of singletons here http://www.youtube.com/watch?v=-FRm3VPhseI

More Related Contents:

  1. Unity singleton manager classes
  2. Thread Safe C# Singleton Pattern
  3. Singleton by Jon Skeet clarification
  4. Singleton with parameters
  5. C++ Singleton design pattern
  6. What is a singleton in C#?
  7. How is Meyers’ implementation of a Singleton actually a Singleton
  8. C# Object Pooling Pattern implementation
  9. C# producer/consumer
  10. The need for volatile modifier in double checked locking in .NET
  11. Large Switch statements: Bad OOP?
  12. Singleton Pattern for C# [closed]
  13. Serialize a Static Class?
  14. Problems with Singleton Pattern
  15. lock keyword in C#
  16. Refactoring code to avoid anti-pattern
  17. When should I choose inheritance over an interface when designing C# class libraries? [closed]
  18. Merge multiple Lists into one List with LINQ
  19. How to avoid multiple instances of windows form in c#
  20. What is difference between MVC, MVP & MVVM design pattern in terms of coding c#
  21. How to implement SOLID principles into an existing project
  22. Multiple Aggregates / Repositories in one Transaction
  23. Singleton httpclient vs creating new httpclient request
  24. Using a Strategy and Factory Pattern with Dependency Injection
  25. Entity Framework Specification Pattern Implementation
  26. DDD Approach to Access External Information
  27. Factory pattern in C#: How to ensure an object instance can only be created by a factory class?
  28. Need an ASP.NET MVC long running process with user feedback
  29. Best practices for multi-form applications to show and hide forms? [closed]
  30. Singleton double-check concurrency issue

Leave a Comment