SqlBulkCopy Options KeepIdentity
SqlBulkCopy Options KeepIdentity
提问于 2018-10-11 19:48:19
我试图移动一个表，我喜欢从源中保留标识值，但是目标表保持自动分配唯一标识符。目标表没有记录。是否需要删除目标表标识设置才能正常工作？
// Create the SqlBulkCopy object using a connection string.
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connectionString, SqlBulkCopyOptions.KeepIdentity))
{
bulkCopy.DestinationTableName = "Log";
bulkCopy.ColumnMappings.Clear();
bulkCopy.ColumnMappings.Add("ID", "ID");
bulk
// How many Rows you want to insert at a time
//bulkCopy.BatchSize = 100000;
bulkCopy.BatchSize = 500;
// Set the timeout.
bulkCopy.BulkCopyTimeout = 0;
// Set up the event handler to notify after 4500 rows.
bulkCopy.SqlRowsCopied +=
new SqlRowsCopiedEventHandler(OnSqlRowsCopied);
bulkCopy.NotifyAfter = 4500;
//( 2093,000 row(s) affected)
//Always stopping at 2093,000
try
{
// INSERT only if row doesn't exist in the destination
//bulkCopy.InsertIfNotExists = true;
// Write from the source to the destination.
bulkCopy.WriteToServer(reader);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
WriteLog("Log_10_11_18.txt", String.Format("Exception = {0}", ex.Message));
return false;
}回答 1
Stack Overflow用户
回答已采纳
发布于 2018-10-11 21:11:45
这对我有用..。
static void Main(string[] args) {
//
// Table definition:
//
// CREATE TABLE dbo.Test(Id INT IDENTITY(1, 1) NOT NULL, Content VARCHAR(MAX) NULL);
//
// Create some dummy data.
var table = new DataTable();
table.Columns.Add(new DataColumn("Id", typeof(System.Int32)));
table.Columns.Add(new DataColumn("Content", typeof(System.String)));
var row = table.NewRow();
row["Id"] = 12345;
row["Content"] = "Testing";
table.Rows.Add(row);
// Bulk copy it in.
using (var connection = new SqlConnection(@"Data Source=(localdb)\ProjectsV13;Initial Catalog=Sandbox;Integrated Security=SSPI"))
using (var bulkCopy = new SqlBulkCopy(connection, SqlBulkCopyOptions.KeepIdentity, null)) {
connection.Open();
bulkCopy.DestinationTableName = "dbo.Test";
bulkCopy.WriteToServer(table);
};
//
// To check results:
//
// SELECT * FROM dbo.Test;
//
}页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/52767857
复制相关文章
相似问题
腾讯云开发者
