using SqlSugar;
using System;
using System.Configuration;

namespace DM_Weight.util
{
    public class SqlSugarHelperNew
    {
        //private static readonly Lazy<SqlSugarClient> _instance = new Lazy<SqlSugarClient>(() =>
        //{
        //    var db = new SqlSugarClient(
        //        new ConnectionConfig()
        //        {
        //            ConnectionString = ConfigurationManager.ConnectionStrings["database"].ToString(),
        //            DbType = DbType.MySql,
        //            IsAutoCloseConnection = true
        //        },
        //        db =>
        //        {
        //            db.Aop.OnLogExecuting = (sql, pars) =>
        //            {
        //                Console.WriteLine(sql);
        //            };
        //        }
        //        );
        //    return db;
        //});
        //public static SqlSugarClient Instance => _instance.Value;


        private static readonly string connectionString = ConfigurationManager.ConnectionStrings["database"].ToString();
        public static SqlSugarScope GetInstance()
        {
            var db = new SqlSugarScope(new ConnectionConfig()
            {
                ConnectionString = connectionString,
                DbType = DbType.MySql,
                IsAutoCloseConnection = true

            },
            db =>
            {
                db.Aop.OnLogExecuting = (sql, pars) =>
                {
                    Console.WriteLine(sql);
                };
            });
            return db;
        }
    }
}