C# SQL server 批量插入（带事务）

最新推荐文章于 2024-04-28 17:27:20 发布

今天又有难题了呢

最新推荐文章于 2024-04-28 17:27:20 发布

阅读量922

点赞数 1

分类专栏： c# 文章标签： c# sql 数据库 sqlserver

本文链接：https://blog.csdn.net/qq_70715413/article/details/127734150

版权

c# 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

废话我不多说

源代码直接冲

 public static int Execute(string sql, object param = null, IDbTransaction transaction = null, int? commandTimeout = null, CommandType? commandType = null, int databaseOption = 1)
        {
            using (var conn = ConnectionFactory.SqlServerConnection_TOP())
            {
                var info = "SQL语句:" + sql + "  \n SQL参数: " + JsonConvert.SerializeObject(param) + " \n";
                // LogHelper.ErrorLog(info);   // 可以记录操作
                var sw = new Stopwatch(); sw.Start();
                transaction=conn.BeginTransaction();
                var restult=1;
                try
                {
                    restult= conn.Execute(sql, param, transaction, commandTimeout, commandType);
                    transaction.Commit();
                }
                catch (Exception ex)
                {
                    if (transaction != null)
                    {
                        transaction.Rollback();
                    }
                    throw;
                }
                sw.Stop();
                LogHelper.LogInformation(info + "耗时:" + sw.ElapsedMilliseconds + (sw.ElapsedMilliseconds > 1000 ? "#####" : string.Empty) + "\n"); // 可以记录操作
                return restult;
            }
        }

public int AddArticle_Collections(List<Article_Collection> list)
        {
            string sql = " Insert into Article_Collection(" +
                " summary," +
                " dircnum," +
                " attachments," +
                " contentid," +
                " contentcnum," +
                " contenttitle," +
                " sectionid," +
                " sectiontype," +
                " contenttype," +
                " coverimage," +
                " cuid," +
                " ctime," +
                " muid," +
                " mtime," +
                " releasetime," +
                " releaseuid," +
                " status," +
                " CreateNo," +
                " ModifyNo," +
                " sceneid," +
                " userid," +
                " level)" +
                " values(@summary,@dircnum,@attachments,@contentid,@contentcnum,@contenttitle,@sectionid,@sectiontype,@contenttype,@coverimage," +
                "@cuid,@ctime,@muid,@mtime,@releasetime,@releaseuid,@status,@CreateNo,@ModifyNo,@sceneid,@userid,@level)";
           
            return TopDBContext.Execute(sql, list);
        }