using (IDbConnection conn = provider.CreateConnection())
{
using (IDbTransaction tran = conn.BeginTransaction())
{
SqlBulkCopy sbc = new SqlBulkCopy(tran.Connection as SqlConnection, SqlBulkCopyOptions.Default, tran as SqlTransaction);
sbc.BatchSize = 10000;
sbc.BulkCopyTimeout = 600;
sbc.DestinationTableName = "LSS_ProductModelReplace";
DataTable dt = ListToDataTable(o.pmrList);
sbc.WriteToServer(dt);
tran.Commit();
}
}