dapper批量插入

曾经终败给现在 2022-08-21 10:54 16阅读 0赞

要用到DapperExtensions库，上码：

/// <summary>
            /// 批量插入功能
            /// </summary>
            public void InsertBatch<T>(IDbConnection conn, IEnumerable<T> entityList, IDbTransaction transaction = null) where T : class
            {
                var tblName = string.Format("dbo.{0}", typeof(T).Name);
                var tran = (SqlTransaction)transaction;
                using (var bulkCopy = new SqlBulkCopy(conn as SqlConnection, SqlBulkCopyOptions.TableLock, tran))
                {
                    bulkCopy.BatchSize = entityList.Count();
                    bulkCopy.DestinationTableName = tblName;
                    var table = new DataTable();
                    DapperExtensions.Sql.ISqlGenerator sqlGenerator = new SqlGeneratorImpl(new DapperExtensionsConfiguration());
                    var classMap = sqlGenerator.Configuration.GetMap<T>();
                    var props = classMap.Properties.Where(x => x.Ignored == false).ToArray();
                    foreach (var propertyInfo in props)
                    {
                        bulkCopy.ColumnMappings.Add(propertyInfo.Name, propertyInfo.Name);
                        table.Columns.Add(propertyInfo.Name, Nullable.GetUnderlyingType(propertyInfo.PropertyInfo.PropertyType) ?? propertyInfo.PropertyInfo.PropertyType);
                    }
                    var values = new object[props.Count()];
                    foreach (var itemm in entityList)
                    {
                        for (var i = 0; i < values.Length; i++)
                        {
                            values[i] = props[i].PropertyInfo.GetValue(itemm, null);
                        }
                        table.Rows.Add(values);
                    }
                    bulkCopy.WriteToServer(table);
                }
            }

另可参考： [http://www.lanhusoft.com/Article/26.html][http_www.lanhusoft.com_Article_26.html]  
DapperExtensions的地址： [https://github.com/tmsmith/Dapper-Extensions][https_github.com_tmsmith_Dapper-Extensions]

[http_www.lanhusoft.com_Article_26.html]: http://www.lanhusoft.com/Article/26.html
[https_github.com_tmsmith_Dapper-Extensions]: https://github.com/tmsmith/Dapper-Extensions