C# 大批量向数据库添加数据

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

private static void SqlFastInsert(DbConnection dbConnection, DbTransaction trans, DataTable dt)  {      using (SqlBulkCopy sqlbulkcopy = new SqlBulkCopy(dbConnection as SqlConnection, SqlBulkCopyOptions.Default, trans as SqlTransaction))      {          sqlbulkcopy.DestinationTableName = dt.TableName;          for (int i = 0; i < dt.Columns.Count; i++)          {              sqlbulkcopy.ColumnMappings.Add(dt.Columns[i].ColumnName, dt.Columns[i].ColumnName);          }          sqlbulkcopy.BatchSize = 10000;          sqlbulkcopy.WriteToServer(dt);      }  }  private static void MySqlFastInsert(DbConnection dbConnection, DbTransaction trans, DataTable dt)  {      MySqlConnector.MySqlBulkCopy mySqlbulkcopy = new MySqlConnector.MySqlBulkCopy(dbConnection as MySqlConnector.MySqlConnection, trans as MySqlConnector.MySqlTransaction);      {          mySqlbulkcopy.DestinationTableName = dt.TableName;          for (int i = 0; i < dt.Columns.Count; i++)          {              mySqlbulkcopy.ColumnMappings.Add(new MySqlConnector.MySqlBulkCopyColumnMapping(i, dt.Columns[i].ColumnName));          }          mySqlbulkcopy.WriteToServer(dt);      }  }  /// <summary>  /// Oracle快速写入  /// </summary>  /// <param name="dbConnection"></param>  /// <param name="trans"></param>  /// <param name="dt"></param>  private static void OracelFastInsert(DbConnection dbConnection, DbTransaction trans, DataTable dt)  {      Oracle.ManagedDataAccess.Client.OracleBulkCopy oraclebulkcopy = new Oracle.ManagedDataAccess.Client.OracleBulkCopy(dbConnection as Oracle.ManagedDataAccess.Client.OracleConnection, Oracle.ManagedDataAccess.Client.OracleBulkCopyOptions.Default);      {            oraclebulkcopy.DestinationTableName = dt.TableName;          for (int i = 0; i < dt.Columns.Count; i++)          {              oraclebulkcopy.ColumnMappings.Add(dt.Columns[i].ColumnName, dt.Columns[i].ColumnName);          }          oraclebulkcopy.BatchSize = 10000;          oraclebulkcopy.WriteToServer(dt);      }  }