OracleBulkCopy批量插入数据

1、OracleBulk程序集引用using ODAC = Oracle.DataAccess.Client

2、有时候不做字段映射，会使导入的数据出错

上代码

 /// <summary>
        /// 批量插入数据
        /// </summary>
        /// <param name="table">数据表</param>
        /// <param name="targetTableName">数据库目标表名</param>
        /// <returns></returns>
        public static bool ExcuteBulkData(DataTable table, string targetTableName)
        {
            bool result = false;
            using (ODAC.OracleConnection conn = new ODAC.OracleConnection(connStr))
            {
                using (ODAC.OracleBulkCopy bulkCopy = new ODAC.OracleBulkCopy(connStr, ODAC.OracleBulkCopyOptions.Default))
                {
                    if (table != null && table.Rows.Count > 0)
                    {
                        bulkCopy.DestinationTableName = targetTableName;
                        for (int i = 0; i < table.Columns.Count; i++)
                        {
                            string col=table.Columns[i].ColumnName;
                            bulkCopy.ColumnMappings.Add(col, col);
                        }
                        conn.Open();
                        bulkCopy.WriteToServer(table);
                        result = true;
                    }
                }
            }
            return result;
        }