F/Config/DBGetConfig.cs

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

namespace F.Config
{
    internal class DBGetConfig
    {

        /// <summary>
        ///  配置连接字符串
        /// </summary>
        /// <returns></returns>
        internal object[] SqlHE()
        {
            try
            {
                //获取WEB.Config中的数据库配置集合；
                ConnectionStringSettingsCollection cssc = ConfigurationManager.ConnectionStrings;
                //如果ConfigurationManager数量不为0则把SqlStr清空；
                FList<F.ADO.Model.DB> SqlStr1 = new FList<F.ADO.Model.DB>();
                for (int i = 0; i < cssc.Count; i++)
                {
                    string name = cssc[i].Name;
                    string ProviderName = cssc[i].ProviderName;
                    string ConnectionString = cssc[i].ConnectionString;

                    F.ADO.Model.DB ModelSql = new F.ADO.Model.DB();
                    ModelSql.Key = name;
                    ModelSql.SqlHelp = ConnectionString;

                    switch (ProviderName)
                    {
                        case "MSSql": ModelSql.DBType = F.ADO.Enum.DBType.MSSql; break;
                        case "Oracle": ModelSql.DBType = F.ADO.Enum.DBType.Oracle; break;
                        case "Access": ModelSql.DBType = F.ADO.Enum.DBType.Access; break;
                        case "MySql": ModelSql.DBType = F.ADO.Enum.DBType.MySql; break;
                        case "File": ModelSql.DBType = F.ADO.Enum.DBType.File; break;
                        case "Memory": ModelSql.DBType = F.ADO.Enum.DBType.Memory; break;
                        case "DB2": ModelSql.DBType = F.ADO.Enum.DBType.DB2; break;
                        case "Excel": ModelSql.DBType = F.ADO.Enum.DBType.Excel; break;
                        case "Sqlite": ModelSql.DBType = F.ADO.Enum.DBType.Sqlite; break;
                        default: ModelSql.DBType = F.ADO.Enum.DBType.MSSql; break;
                    }

                    SqlStr1.Add(ModelSql);
                }

                object[] obj = { SqlStr1, F.IO.Config.GetConfig("DefaultSqlLinkKey") };
                return obj;
            }
            catch (Exception ex)
            {
                throw new Exception("读取web.config中的数据库连接字符串失败！");
            }
        }
    }
}