All pastes #71909 Raw Edit

Anonymous

public text v1 · immutable
#71909 ·published 2006-06-26 09:52 UTC
rendered paste body
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;

namespace nTier
{
    public class DataConnection
    {

        #region -- private variables --
        private volatile static DataConnection uniqueInstance;
        private static object syncRoot = new Object();
        private static string strConnectionString = "server=(local)\\SQLEXPRESS;Integrated Security=true;;Database=PCMS;";
        private SqlConnection sqlConnection;
        #endregion

        public SqlConnection objConnection
        {
            get { return sqlConnection; }
        }

        #region -- private constructor --
        private DataConnection()
        {
            sqlConnection = new SqlConnection(strConnectionString);
        }
        #endregion

        #region -- Get Single Instance --
        public static DataConnection GetInstance()
        {
            if (uniqueInstance == null)
            {
                lock (syncRoot)
                {
                    if (uniqueInstance == null)
                    {
                        uniqueInstance = new DataConnection();
                    }
                }
            }
            return uniqueInstance;
        }
        #endregion

    }
}