C# SqlSugar增删改查

一篇好文章

已于 2022-10-10 16:33:29 修改

阅读量931

点赞数

文章标签： c# sqlserver 数据库

于 2022-10-10 16:32:31 首次发布

本文链接：https://blog.csdn.net/zhf19900503/article/details/127247341

版权

        static void Main(string[] args)
        {
            ConnectionConfig connectionConfig = new ConnectionConfig()
            {
                DbType = DbType.SqlServer,
                ConnectionString = "Server=.;Initial Catalog=Test;User ID=Test;Password=Test",
                IsAutoCloseConnection = true
            };

            using (SqlSugarClient db = new SqlSugarClient(connectionConfig))
            {
                //调式代码 用来打印SQL 
                db.Aop.OnLogExecuting = (sql, pars) =>
                {
                    Console.WriteLine(sql + "\r\n" + db.Utilities.SerializeObject(pars.ToDictionary(it => it.ParameterName, it => it.Value)));
                };

                //新增返回ID
                var entity = db.Insertable<EmailEntity>(new EmailEntity()
                {
                    EmailArr = "test@test.com",