Dapper批量插入数据

SqlConnection conn = new SqlConnection(connString);
            conn.Open();
            SqlTransaction trans = conn.BeginTransaction();
            try
            {
                //插入操作
                conn.Execute(@"insert into News(ID,Sys_NavigationID,NewsId,Title,Author,Summary,...) 
                values(@ID,@Sys_NavigationID,@NewsId,@Title,@Author,...)", list, transaction: trans);
                trans.Commit();
            }catch(Exception e)
            {
                trans.Rollback();
            }
            conn.Close();

 

posted @ 2021-04-07 11:16  RookieCoderAdu  阅读(535)  评论(0编辑  收藏  举报