基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：78630559

本次赞助数额为： 3 元　

支付宝支付

微信支付

   源码介绍

---

使用MySql Sqlsugar框架实现简单的数据管理

using System;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using LGMG.Comm;
using LGMG.ModelsLib;
using SqlSugar;
using MySql.Data.MySqlClient;
namespace UintTestProject
{
    [TestClass]
    public class UnitTest1
    {
        [TestMethod]
        public void TestMethod1()
        {
            InitDb();
        }
        
        public void InitDb()
        {
            var db = SqlHelper.GetSqlClient();
            LogHelper.Info("连接到数据库LGMG");

            db.DbMaintenance.CreateDatabase();
            
            db.CodeFirst.InitTables<ConfigInfo>();
            db.CodeFirst.InitTables<LoginRecord>();
            db.CodeFirst.InitTables<UserAccount>();
            db.CodeFirst.InitTables<Role>();
            db.CodeFirst.InitTables<RoleRight>();
            db.CodeFirst.InitTables<SysLog>();
            LogHelper.Info("向数据库中插入表: ConfigInfo, LoginRecord,UserAccount, Role, RoleRight, SysLog");
        }
    }

}

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

namespace LGMG.Comm
{
    public class SqlHelper
    {
        public static SqlSugarClient GetSqlClient()
        {
            SqlSugarClient db = new SqlSugarClient(new ConnectionConfig()
            {
                ConnectionString = ConfigHelper.GetConnectionStringConfig("LGMGDB"),//"data source=localhost;database=LGMG_DB;user id=root;password=ali88",
                DbType = DbType.MySql,
                IsAutoCloseConnection = true,
                InitKeyType = InitKeyType.Attribute,
                AopEvents = new AopEvents
                {
                    OnLogExecuting = (sql, p)=>
                    {
                        Console.WriteLine(sql);
                        Console.WriteLine(string.Join(",", p?.Select(it => it.ParameterName ":" it.Value)));
                    }
                }
            });

            return db;
        }
    }
}