private int BulkCopyByPage(ETLInfo etlInfo, int pageSize, int pageIndex, BulkCopy bcp, OleDbConnection sourceConnection, DbConnection DestinationConnection)
{
string sql = etlInfo.SourceTable.ToQuerySQL(pageSize, pageIndex);;
try
{
DataTable dt = OleDbHelper.ExecuteDataTable(sourceConnection, sql);
if (dt == null || dt.Rows.Count == 0)
{
return(0);
}
bcp.Insert(etlInfo.DestinationTableName, dt, etlInfo.ColumnMapping);
return(dt.Rows.Count);
}
catch (Exception ex)
{
string errorString = string.Format("转移失败,数据源SQL:{0}...", sql);
File.AppendAllText(@"bulkcopy.log", errorString);
throw;
}
}
public static void BulkInsert(DbConnection conn, string providerName, string tableName, DataTable sourceData, Dictionary <string, string> columnMappings = null)
{
BulkCopy bulkCopy = new BulkCopy(conn.ConnectionString, BulkCopy.GetSupportedDBType(providerName));
bulkCopy.Insert(tableName, sourceData, columnMappings);
}
public static void BulkInsert(OleDbConnection conn, string tableName, DataTable sourceData, Dictionary<string, string> columnMappings = null)
{
BulkCopy bulkCopy = new BulkCopy(conn);
bulkCopy.Insert(tableName, sourceData, columnMappings);
}
public static void BulkInsert(DbConnection conn, string providerName, string tableName, DataTable sourceData, Dictionary<string, string> columnMappings = null)
{
BulkCopy bulkCopy = new BulkCopy(conn.ConnectionString, BulkCopy.GetSupportedDBType(providerName));
bulkCopy.Insert(tableName, sourceData, columnMappings);
}
public static void BulkInsert(OleDbConnection conn, string tableName, DataTable sourceData, Dictionary <string, string> columnMappings = null)
{
BulkCopy bulkCopy = new BulkCopy(conn);
bulkCopy.Insert(tableName, sourceData, columnMappings);
}
