批量删除和插入数据操作 sqlserver

 conn.TranBegin();
                conn.TranUpdate("delete from STK_BASE_INFO");
                SqlBulkCopy _bulkCopy = new SqlBulkCopy(connectionString, SqlBulkCopyOptions.FireTriggers);
                _bulkCopy.BatchSize = 0;
                _bulkCopy.DestinationTableName = "STK_BASE_INFO";
                _bulkCopy.WriteToServer(dt);//参数是进行更新的数据表对象
                conn.TranCommit();

 

dt要求完全匹配数据库结构