Web_Faces_Prod/Face.Domain/Entities/SqlSugarBase.cs

using SqlSugar;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.Entity;
using System.Diagnostics;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Threading.Tasks;
using System.Web.Services.Description;

namespace Face.Domain.Entities
{
    public static class SqlSugarBase
    {
        public static SqlSugarClient GesmartDb()
        {
            SqlSugarClient Db = new SqlSugarClient(new ConnectionConfig()
            {
                ConnectionString = "Server=blv-cloud-db.mysql.rds.aliyuncs.com;Database=Face;Uid=blv_rcu;Pwd=fnadiaJDIJ7546;charset=utf8;port=3307;",
                DbType = SqlSugar.DbType.MySql,
                InitKeyType = InitKeyType.Attribute,//从特性读取主键和自增列信息
                IsAutoCloseConnection = true,//开启自动释放模式和EF原理一样我就不多解释了
            });
            //用来打印Sql方便调式
            Db.Aop.OnLogExecuting = (sql, pars) =>
            {
                Db.Utilities.SerializeObject(pars.ToDictionary(it => it.ParameterName, it => it.Value));
                Debug.WriteLine(sql);
            };
            return Db;
        }



        public static SqlSugarClient Gesmartblv_rcu_db()
        {
            SqlSugarClient Db = new SqlSugarClient(new ConnectionConfig()
            {
                ConnectionString = "Server=blv-cloud-db.mysql.rds.aliyuncs.com;Database=blv_rcu_db;Uid=blv_rcu;Pwd=fnadiaJDIJ7546;charset=utf8;port=3307;",//数据库连接串
                DbType = SqlSugar.DbType.MySql,
                InitKeyType = InitKeyType.Attribute,//从特性读取主键和自增列信息
                IsAutoCloseConnection = true,//开启自动释放模式和EF原理一样我就不多解释了
            });
            //用来打印Sql方便调式    
            Db.Aop.OnLogExecuting = (sql, pars) =>
            {
                Db.Utilities.SerializeObject(pars.ToDictionary(it => it.ParameterName, it => it.Value));
            };
            return Db;
        }


        public static SqlSugarScope Db = new SqlSugarScope(new ConnectionConfig()
        {
            DbType = SqlSugar.DbType.MySql,
            IsAutoCloseConnection = true,
            ConnectionString = "Server=blv-cloud-db.mysql.rds.aliyuncs.com;Database=Face;Uid=blv_rcu;Pwd=fnadiaJDIJ7546;charset=utf8;port=3307;",
        },
        db =>
        {
            db.Aop.OnLogExecuting = (s, p) =>
            {
                Debug.WriteLine(s);
            };
        });

        public static SqlSugarScope authoriydb = new SqlSugarScope(new ConnectionConfig()
        {
            DbType = SqlSugar.DbType.MySql,
            IsAutoCloseConnection = true,
            ConnectionString = "Server=blv-cloud-db.mysql.rds.aliyuncs.com;Database=AuthorityDB;Uid=blv_rcu;Pwd=fnadiaJDIJ7546;charset=utf8;port=3307;",
            
        },
    db =>
    {
            //db.DbMaintenance.CreateDatabase(); //个别数据库不支持
            //Type[] types = Assembly
            //.LoadFrom($@"D:\BLV_SYNC\RD_WEB\SynologyDrive\欧阳磊\Faces\Face.Web\bin\Face.Domain.dll")//如果 .dll报错，可以换成 xxx.exe 有些生成的是exe 
            //.GetTypes().Where(it => it.FullName.Contains("Face.Domain.Application.FaceAll."))//命名空间过滤，当然你也可以写其他条件过滤
            //.ToArray();//断点调试一下是不是需要的Type，不是需要的在进行过滤
            //    db.CodeFirst.SetStringDefaultLength(200).InitTables(types);//根据types创建表
            //单例参数配置，所有上下文生效
            db.Aop.OnLogExecuting = (s, p) =>
        {
            Debug.WriteLine(s);
        };
    });







        ///巫工数据库
        public static SqlSugarScope WuDb = new SqlSugarScope(new ConnectionConfig()
        {
            DbType = SqlSugar.DbType.SqlServer,
            IsAutoCloseConnection = true,
            ConnectionString = "Data Source=pms.boonlive-rcu.com;Initial Catalog=RICS_WS;User ID=blw;Password=blw@123",
        },
        db =>
        {
            //db.DbMaintenance.CreateDatabase(); //个别数据库不支持
            //Type[] types = Assembly
            //.LoadFrom($@"D:\BLV_SYNC\RD_WEB\SynologyDrive\欧阳磊\Faces\Face.Web\bin\Face.Domain.dll")//如果 .dll报错，可以换成 xxx.exe 有些生成的是exe 
            //.GetTypes().Where(it => it.FullName.Contains("Face.Domain.Application.FaceAll."))//命名空间过滤，当然你也可以写其他条件过滤
            //.ToArray();//断点调试一下是不是需要的Type，不是需要的在进行过滤
            //    db.CodeFirst.SetStringDefaultLength(200).InitTables(types);//根据types创建表
            //单例参数配置，所有上下文生效
            db.Aop.OnLogExecuting = (s, p) =>
            {
                Debug.WriteLine(s);
            };
        });
    }
}