六年级答案SqlBulkCopy结合事务批量保存数据到数据库 ///<summary>二年级应用题大全
///保存到数据库
///</summary>
///<param name="mDCCampaignList"></param>
///<param name="mDCAdgroupList"></param>
///<param name="mDCKeywordList"></param>
美国自由行private void SaveToServer(IList<DCCampaign> mDCCampaignList, IList<DCADGroup> mDCAdgroupList, IList<DCKeyword> mDCKeywordList) {
using (SqlConnection conn = new DBHelper().GetSqlConnection())
{
conn.Open();
using (SqlTransaction tran = conn.BeginTransaction())
{
try
{
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(conn, SqlBulkCopyOptions.Default, tran))
{
//設置⼀个批，写⼊多少条记录
bulkCopy.BatchSize = 10000;
bulkCopy.BulkCopyTimeout = 60;
回锅肉的做法大全////設置 NotifyAfter 属性，以便在每拷贝 10000 条记录⾄数据表後，呼叫事件处理函数
//bulkCopy.NotifyAfter = 10000;
//bulkCopy.SqlRowsCopied += new SqlRowsCopiedEventHandler(OnSqlRowsCopied);
/
/設置要写⼊的数据库
讲小红帽的故事bulkCopy.DestinationTableName = "dbo.DC_Campaign";
DataTable dt = mDCCampaignList.ToDataTable();
bulkCopy.WriteToServer(dt);
}
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(conn, SqlBulkCopyOptions.Default, tran))
{
贺卡内容
//設置⼀个批，写⼊多少条记录
bulkCopy.BatchSize = 10000;
bulkCopy.BulkCopyTimeout = 60;
////設置 NotifyAfter 属性，以便在每拷贝 10000 条记录⾄数据表後，呼叫事件处理函数
/
/bulkCopy.NotifyAfter = 10000;
//bulkCopy.SqlRowsCopied += new SqlRowsCopiedEventHandler(OnSqlRowsCopied);
//設置要写⼊的数据库
bulkCopy.DestinationTableName = "dbo.DC_ADGroup";
DataTable dt = mDCAdgroupList.ToDataTable();
bulkCopy.WriteToServer(dt);三西
}
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(conn, SqlBulkCopyOptions.Default, tran))
{
//設置⼀个批，写⼊多少条记录
bulkCopy.BatchSize = 100000;
bulkCopy.BulkCopyTimeout = 60;
////設置 NotifyAfter 属性，以便在每拷贝 10000 条记录⾄数据表後，呼叫事件处理函数
//bulkCopy.NotifyAfter = 10000;
//bulkCopy.SqlRowsCopied += new SqlRowsCopiedEventHandler(OnSqlRowsCopied);
//設置要写⼊的数据库
bulkCopy.DestinationTableName = "dbo.DC_Keyword";
DataTable dt = mDCKeywordList.ToDataTable();
bulkCopy.WriteToServer(dt);
}
//事务提交
tran.Commit();
}
catch(Exception e)
{
//事务回滚
tran.Rollback();
throw e;
}
finally魔兽争霸三
{
tran.Dispo();
}
}
}
}
