批量插入数据For SQL and ORACLE

ORACLE

using Oracle.DataAccess.Client;

从Oracle官方网站下载11.1.0.7

        /// <summary>
        /// 大批量入库处理
        /// </summary>
        /// <param name="dtData"></param>
        /// <returns></returns>
        public Boolean GetSqlBulkCopy(DataSet dsData)
        {
            Boolean bolReturn = false;
            foreach (DataTable dtData in dsData.Tables)
            {
                bolReturn = GetSqlBulkCopyByTable(dtData);
            }
            return bolReturn;
        }

        public Boolean GetSqlBulkCopyByTable(DataTable dtData)
        {
            Boolean bolReturn = false;
            OracleBulkCopy bulkCopy = null;
            try
            {
                bulkCopy = new OracleBulkCopy(DbConfig.connStringForOraAccess);
                bulkCopy.DestinationTableName = dtData.TableName;
                bulkCopy.WriteToServer(dtData);
                bolReturn = true;
            }
            catch
            {
                bolReturn = false;
                throw;
            }
            finally
            {
                bulkCopy = null;
            }
            return bolReturn;
        }

 

SQL Server

 

        /// <summary>
        /// 大批量入库处理
        /// </summary>
        /// <param name="dtData"></param>
        /// <returns></returns>
        public Boolean GetSqlBulkCopy(string ConnectionString, DataSet dsData)
        {
            Boolean bolReturn = false;
            foreach (DataTable dtData in dsData.Tables)
            {
                bolReturn = GetSqlBulkCopyByTable(ConnectionString,dtData);
            }
            return bolReturn;
        }

        public Boolean GetSqlBulkCopyByTable(string ConnectionString, DataTable dtData)
        {
            Boolean bolReturn = false;
            SqlBulkCopy bulkCopy = null;
            try
            {
                bulkCopy = new SqlBulkCopy(ConnectionString);
                bulkCopy.DestinationTableName = dtData.TableName;
                bulkCopy.WriteToServer(dtData);
                bolReturn = true;
            }
            catch
            {
                bolReturn = false;
                throw;
            }
            finally
            {
                bulkCopy = null;
            }
            return bolReturn;
        }

        public Boolean GetSqlBulkCopyByTable(string ConnectionString, DataTable dtData, string tbName)
        {
            if (tbName == null || tbName == "")
            {
                return GetSqlBulkCopyByTable(ConnectionString, dtData);
            }
            else
            {
                Boolean bolReturn = false;
                SqlBulkCopy bulkCopy = null;
                try
                {
                    bulkCopy = new SqlBulkCopy(ConnectionString);
                    bulkCopy.DestinationTableName = tbName;
                    bulkCopy.WriteToServer(dtData);
                    bolReturn = true;
                }
                catch
                {
                    bolReturn = false;
                    throw;
                }
                finally
                {
                    bulkCopy = null;
                }
                return bolReturn;
            }
        }