using Npgsql;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace HH.AMS.Ex.NpgsqlServices
{
    public enum DataBaseType
    {
        SqlServer,
        MySql,
        Oracle,
        Aceess
    }

    public class Connections
    {
        private static readonly Connections instance = new Connections();

        /// <summary>
        /// 获取单实例
        /// </summary>
        public static Connections Instance
        {
            get
            {
                return instance;
            }
        }

        /// <summary>
        /// 连接Npgsql
        /// </summary>
        /// <returns></returns>
        public NpgsqlConnection GetNpgsqlConnection(string NpgsqlConnetctionString)
        {
            //获取Npgsql数据库连接
            NpgsqlConnection conn = new NpgsqlConnection(NpgsqlConnetctionString);
            if (conn.State == ConnectionState.Closed)
                conn.Open();
            return conn;
        }


        /// <summary>
        /// 连接字符串
        /// </summary>
        private  string connnctionString = "";

        public string GetConnectionString
        {
            get
            {
                if (connnctionString == "")
                {
                    connnctionString = System.Configuration.ConfigurationManager.AppSettings["Npgsql"];
                    return connnctionString;
                }
                else
                {
                    return connnctionString;
                }
            }
        }
    }
}