sqlsugar帮助类

using Mes.Common;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Mes.SqlHelper
{
    public class SqlSugarHelper
    {
        public static string connString = Configs.GetValue("ConnectionStrings:MySqlConnStr"); //读取的是 web.config中配置的内容
                                                                                              //用单例模式
        public static SqlSugarScope Db = new SqlSugarScope(new ConnectionConfig()
        {
            ConnectionString = connString,//连接符字串
            DbType = SqlSugar.DbType.MySql,//数据库类型
            IsAutoCloseConnection = true //不设成true要手动close
        },
      db =>
      {
          //(A)全局生效配置点，一般AOP等配置写这儿
          //调试SQL事件，可以删掉
          db.Aop.OnLogExecuting = (sql, pars) =>
          {
              Console.WriteLine(sql);//输出sql,查看执行sql
              //5.0.8.2 获取无参数化 SQL 
              UtilMethods.GetSqlString(SqlSugar.DbType.MySql, sql, pars);
          };
      });
    }
}



静态帮助类

    public class SqlSugarHelper
    {
        public static string connectionString;
        public static DbType dbtype = DbType.MySql;

        public static void SetDBType(string dbType)
        {
            switch (dbType.ToLower())
            {
                case "sqlserver":
                    SqlSugarHelper.dbtype = DbType.SqlServer;
                    break;
                case "sqlite":
                    SqlSugarHelper.dbtype = DbType.Sqlite;
                    break;
                case "mysql":
                    SqlSugarHelper.dbtype = DbType.MySql;
                    break;
                default:
                    SqlSugarHelper.dbtype = DbType.MySql;
                    break;
            }
        }
        public static void SetConnectionString(string connectionString)
        {
            SqlSugarHelper.connectionString = connectionString;
        }
        /// <summary>
        /// 获取数据库连接实体，禁止使用静态变量对接
        /// SqlSugarScope支持线程安全
        /// </summary>
        public static SqlSugarScope Db
        {
            get
            {
            return new SqlSugarScope(new ConnectionConfig()
            {
                    ConnectionString = connectionString,//连接符字串
                    DbType = dbtype,//数据库类型
                    IsAutoCloseConnection = true //不设成true要手动close
            },
            db =>
            {
            //(A)全局生效配置点
            //调试SQL事件，可以删掉
              db.Aop.OnLogExecuting = (sql, pars) =>
              {
                  Console.WriteLine(sql);
                //输出sql,查看执行sql
                //5.0.8.2 获取无参数化 SQL 
                //UtilMethods.GetSqlString(DbType.SqlServer,sql,pars)
              };});
            }
        }
    }