草庐IT

MySqlBulkCopy

全部标签

.NET Core MySqlBulkCopy 批量新增数据

MySqlConnector有个MySqlBulkCopy批量新增数据方法,不过只能用DataTable,需要把list转成DataTable代码如下:MySqlBulkCopymySqlBulkCopy=newMySqlBulkCopy(conn){  DestinationTableName="userinfo"};mySqlBulkCopy.ColumnMappings.AddRange(table.Columns.Cast().Select(colum=>newMySqlBulkCopyColumnMapping{DestinationColumn=colum.ColumnName,S