基于SqlSugar的数据库访问处理的封装，支持.net FrameWork和.net core的项目调用

public DbContext()
        {
            this.DbSetting = ConfigHelper.GetDbSettings();
            Init(this.DbSetting.DbConfigName);
        }
        public DbContext(string dbConfigName)
        {
            if (this.DbSetting == null)
            {
                this.DbSetting = ConfigHelper.GetDbSettings();
            }
            Init(dbConfigName);
        }

public DbContext()
        {
            //默认采用配置项名
            //appSettings/DefaultDb 配置项为指定连接字符串的name
            var dbConfigName = ConfigurationManager.AppSettings["DefaultDb"];
            Init(dbConfigName);
        }

/// <summary>
    /// 数据库配置信息
    /// </summary>
    public class DbSetting
    {
        /// <summary>
        /// 默认指定的连接字符串集合的配置项名称
        /// </summary>
        public string DbConfigName { get; set; }
        /// <summary>
        /// 数据库类型，默认为SQLServer
        /// </summary>
        public string DbType { get; set; } = "sqlserver";
        /// <summary>
        /// 连接字符串
        /// </summary>
        public string ConnectionString { get; set; }
    }

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <connectionStrings>
    <!--Sqlserver数据库的连接字符串-->
    <add name="sqlserver" providerName="System.Data.SqlClient" connectionString="Persist Security Info=False;Data Source=(local);Initial Catalog=WinFramework;Integrated Security=SSPI" />
    <!--MySQL数据库的连接字符串-->
    <add name="mysql" providerName="MySql.Data.MySqlClient" connectionString="Server=localhost;Database=winframework;Uid=root;Pwd=123456;SslMode=none" />
    <!--sqlite数据库字符串，路径符号|DataDirectory|代表当前运行目录-->
    <add name="sqlite" providerName="System.Data.SQLite" connectionString="Data Source=|DataDirectory|\WinFramework.db;Version=3;" />
    <!--PostgreSQL数据库的连接字符串-->
    <add name="npgsql" providerName="Npgsql" connectionString="Server=localhost;Port=5432;Database=winframework;User Id=postgres;Password=123456" />
    <!--不受驱动影响，32位64位均可使用-->
    <add name="oracle" providerName="OracleManaged" connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));User ID=win;Password=win" />
    <!--达梦数据库的连接字符串-->
    <add name="Dm" providerName="Dm" connectionString="Server=localhost;User ID=SYSDBA;PWD=SYSDBA;Database=WINFRAMEWORK;" />
  </connectionStrings>
  
  <appSettings>
    <!--指定默认的数据库类型，如果不指定则使用第一个连接字符串-->
    <add key="DefaultDb" value="sqlserver" />
    <!--字典、权限组件的数据库类型：mysql、npgsql、oracle、sqlite、sqlserver等，默认为sqlserver可不写-->
    <add key="ComponentDbType" value="sqlserver" />
  </appSettings>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.8" />
  </startup>

{
  "ConnectionStrings": {
    "Default": "Server=.; Database=WeixinBootstrap2; Trusted_Connection=True;",
    "Oracle": "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));User ID=C##ABP;Password=abp",
    "MySql": "Server=localhost;Database=myprojectdb;Uid=root;Pwd=123456;",
    "PostgreSQL": "Server=localhost;Port=5432;Database=myprojectdb;User Id=postgres;Password=123456"
  },
  "DbSetting": {
    "DefaultDb": "Default",
    "ComponentDbType": "sqlserver"
  },
   ...........   
  }

/// <summary>
        /// 根据承载环境是netframework或者是.netcore，读取配置信息。
        /// 在.netframework中的app.config的appSettings中配置DefaultDb，ComponentDbType，连接字符串在connectionStrings中配置
        /// 在.netcore中的appSettings.json的DbSetting节点中配置DefaultDb，ComponentDbType，连接字符串在ConnectionStrings中配置
        /// </summary>
        /// <returns></returns>
        public static DbSetting GetDbSettings()
        {
            //初始化承载配置信息对象
            var dbSetting = new DbSetting();
#if NETFRAMEWORK
            //基于.net frameowork下读取app.config的配置
            dbSetting.DbType = ConfigurationManager.AppSettings["ComponentDbType"] ?? "sqlserver";
            dbSetting.DbConfigName = ConfigurationManager.AppSettings["DefaultDb"];
            var setting = ConfigurationManager.ConnectionStrings[1];//默认第一个连接字符串
            if (!string.IsNullOrWhiteSpace(dbSetting.DbConfigName))
            {
                //如果配置节点名称存在，则读取它的连接字符串
                setting = ConfigurationManager.ConnectionStrings[dbSetting.DbConfigName];
            }
            if (setting != null)
            {
                dbSetting.ConnectionString = setting.ConnectionString;
            }
#else
            //基于.net core下的读取appsettings.json的配置信息
            dbSetting.DbType = GetSectionValue("DbSetting:ComponentDbType") ?? "sqlserver";
            dbSetting.DbConfigName = GetSectionValue("DbSetting:DefaultDb");
            
            var connectionStringKey = string.Format("ConnectionStrings:{0}", dbSetting.DbConfigName);
            dbSetting.ConnectionString = GetSectionValue(connectionStringKey);
#endif
            return dbSetting;
        }

/// <summary>
        /// 获取所有记录
        /// </summary>
        public virtual async Task<ListResultDto<TEntity>> GetAllAsync()
        {
            var list = await EntityDb.GetListAsync();
            return new ListResultDto<TEntity>()
            {
                Items = list
            };
        }

/// <summary>
        /// 根据字典类型名称获取所有该类型的字典列表集合(Key为名称，Value为值）
        /// </summary>
        /// <param name="dictTypeName">字典类型名称</param>
        /// <returns></returns>
        public async Task<Dictionary<string, string>> GetDictByDictType(string dictTypeName)
        {
            var query = this.dbContent.Client.Queryable<DictDataInfo, DictTypeInfo>(
                (d, t) => d.DictType_ID == t.Id && t.Name == dictTypeName)
                .Select(d => d); //联合条件获取对象
            query = query.OrderBy(d => d.DictType_ID).OrderBy(d => d.Seq);//排序
            var list = await query.ToListAsync();//获取列表
            var dict = new Dictionary<string, string>();
            foreach (var info in list)
            {
                if (!dict.ContainsKey(info.Name))
                {
                    dict.Add(info.Name, info.Value);
                }
            }
            return dict;
        }