批量删除和插入数据操作 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要求完全匹配数据库结构