DbCommon/ConfigurationDataBaseInfo.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using System.Configuration;

namespace NLKIRADBCommon
{
    public static class ConfigurationDataBaseInfo
    {
        private static SortedList<string, string> configManagers;

        public static SortedList<string, string> ConfigManagers
        {
            get { return ConfigurationDataBaseInfo.configManagers; }
            set { ConfigurationDataBaseInfo.configManagers = value; }
        }

        private static void Read()
        {
            ConfigurationDataBaseInfo.configManagers = new SortedList<string, string>();
            foreach (ConnectionStringSettings s in ConfigurationManager.ConnectionStrings)
            {
                if (!configManagers.ContainsKey(s.Name.ToLower()))
                    configManagers.Add(s.Name.ToLower(), s.ConnectionString);
            }
        }

        public static string GetConnectionString(string dbKey)
        {
            if (configManagers == null)
                ConfigurationDataBaseInfo.Read();

            string value = null;
            if (configManagers.TryGetValue(dbKey.ToLower(), out value))
                return value;
            else
                return value;
        }

        public static string GetFirstKey()
        {
            if (configManagers == null)
                ConfigurationDataBaseInfo.Read();

            if (configManagers == null)
                return null;

            foreach (KeyValuePair<string, string> keyValuePair in configManagers)
            {
                foreach (string str in Enum.GetNames(typeof(dbName))) 
                {
                    if (keyValuePair.Key.ToLower() == str.ToLower())
                        return str;
                }
            }

            return "";
        }
    }
}