SqlBulkCopy批量插入数据库

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