ado.net 批量添加更新删除

<div class="blogpost-body" id="cnblogs_post_body">
自曾列就别往下看别折腾了 
<div>
 使用 SqlBulkCopy ，dataTable 必须跟sql里面的表字段完全一样
</div>
下面在sqlserver中演示
mysql 请google MySqlBulkLoader 
oracle 请google OracleBulkCopy
表结构
<div class="cnblogs_code">
 <pre class="blockcode"> DROP TABLE [dbo].[Product]
 GO
 CREATE TABLE [dbo].[Product] (
 [Id] varchar(36) NOT NULL ,
 [Name] varchar(255) NOT NULL ,
 [Price] decimal(18,4) NOT NULL
 )
 GO
 ALTER TABLE [dbo].[Product] ADD PRIMARY KEY ([Id])
 GO</pre>
</div>
批量添加
<div class="cnblogs_code">
 <pre class="blockcode"> public static void Insert<T>(string connectionString, List<T> dataList, string destinationTableName, int batchSize = 0)
 {
 DataTable dataTable = ConvertToDataTable(dataList);
 Insert(connectionString, dataTable, destinationTableName, batchSize);
 }

 public static void Insert(string connectionString, DataTable dataTable, string destinationTableName, int batchSize = 0)
 {
 using (SqlConnection connection = new SqlConnection(connectionString))
 {
 if (connection.State != ConnectionState.Open)
 {
 connection.Open();
 }
 using (SqlTransaction transaction = connection.BeginTransaction())
 {
 using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection, SqlBulkCopyOptions.Default, transaction))
 {
 bulkCopy.BatchSize = batchSize;
 bulkCopy.DestinationTableName = destinationTableName;
 try
 {
 bulkCopy.WriteToServer(dataTable);
 transaction.Commit();
 }

ado.net 批量添加 更新 删除

ado.net 批量添加更新删除