如何用C＃语言实现数据库连接的单例设计模式？ [英] How to implement singleton design patter for database connection in C# language ?

问题描述

大家好，

i有winform c＃visual studio 2012

i想要实现单身设计模式

其实我不知道我想在每次需要请求数据库时打开一个新的连接。

在进入数据库之前，我想检查连接是否已经打开

if它打开，所以不需要创建一个新实例

否则，创建。

在我的应用程序的每个页面中，我只想在需要数据时调用我的单例数据库无需打开或关闭数据库连接



我尝试过：

Hi everybody,
i have winform c# visual studio 2012
i want to implement "singleton design pattern"
in fact i don't want to open a new connection every time i need to request the database.
before going to the database, i want to check if the connection is already open or not
if it opens, so no need to create a new instance
otherwise, create.
And in every page of my app i just want to call my singleton whenever i need data from database without having to open or close again a DB connection

What I have tried:

namespace GNMS
{
    public class Godaddy
    {
        //singleton has a reference to itself
        private static Godaddy dbconec;
        private Godaddy() { }//private constructor so that it cannot be instantiated outside this class

        //grabs instance of singleton pattern
        public static Godaddy GetInstance()
        {
            if (dbconec == null) //check if  an instance has been created else  can create a new instance
            {
                dbconec = new Godaddy();
            }
            return dbconec;
        }

        public string connectDB() //Database connection 
        {

            try
            {

                //create a string connection
                string strconnection;
                strconnection = "Server=x.x.x.x; Database =xxx; Uid = xxx; Password =xxx;CharSet=utf8; Connect Timeout=60;";
                //initialize the connection to DB
                MySqlConnection conn = new MySqlConnection(strconnection);

                conn.Open();

                return strconnection;

                //conn.Close();

            }

            catch (Exception ex)
            {

                return ex.Message;
            }

        }

        ////
    }
}

推荐答案

C＃中单身人士的标准如何 - C＃深度：实施单身人士模式 [ ^ ]

The standard "how to" for Singletons in C# -- C# in Depth: Implementing the Singleton Pattern[^]

实际上（除了嵌入式应用程序，大小是关键的），没有理由实现单个连接... ADO.NET使用连接池解决方案来最小化连接时间...你可以依赖它（我在100多个客户的网站上安装了一个Web应用程序，处理成千上万的请求 - 全部用于数据 - 在任何时候......它依赖于ASP.NET池）...



连接池 [< a href =https://msdn.microsoft.com/en-us/library/bb39954 3（v = vs.110）.aspxtarget =_ blanktitle =New Window> ^ ]

SQL Server连接池（ADO.NET） [ ^ ]

ADO.NET连接池概览 [ ^ ]

In reality (except embedded applications maybe, where size is critical), there is no reason to implement a single connection...ADO.NET uses a connection pool solution to minimize time of connection...You can rely on it (I have a web application installed at over 100 customer's site, handling thousands of request - all for data - in any minute...It relies on ASP.NET pool)...

Connection Pooling[^]
SQL Server Connection Pooling (ADO.NET)[^]
ADO.NET Connection Pooling at a Glance[^]

这篇关于如何用C＃语言实现数据库连接的单例设计模式？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！