public BulkCopy(string connStr, BulkCopySupportDB DbType)
{
switch (DbType)
{
case BulkCopySupportDB.MSSQL: bulkCopyWrapper = new SqlBulkCopyWrapper(new SqlConnection(connStr)); break;
case BulkCopySupportDB.Oracle: bulkCopyWrapper = new OracleBulkCopyWrapper(new OracleConnection(connStr)); break;
default: throw new Exception("Not Support DbType");
}
}
public BulkCopy(string connStr, BulkCopySupportDB DbType)
{
switch (DbType)
{
case BulkCopySupportDB.MSSQL: bulkCopyWrapper = new SqlBulkCopyWrapper(new SqlConnection(connStr)); break;
case BulkCopySupportDB.Oracle: bulkCopyWrapper = new OracleBulkCopyWrapper(new OracleConnection(connStr)); break;
default: throw new Exception("Not Support DbType");
}
}
public BulkCopy(OleDbConnection conn)
{
OleDbConnectionStringBuilder oleDbStringBuilder = new OleDbConnectionStringBuilder(conn.ConnectionString);
oleDbStringBuilder.Remove("provider");
IBulkCopyWrapper bulkCopyWrapper = null;
switch (conn.Provider)
{
case "sqloledb":
bulkCopyWrapper = new SqlBulkCopyWrapper(new SqlConnection(oleDbStringBuilder.ConnectionString));
break;
case "oraoledb":
bulkCopyWrapper = new OracleBulkCopyWrapper(new OracleConnection(oleDbStringBuilder.ConnectionString));
break;
default: throw new Exception("Not Support OleDbConnection");
}
}
public BulkCopy(OleDbConnection conn)
{
OleDbConnectionStringBuilder oleDbStringBuilder = new OleDbConnectionStringBuilder(conn.ConnectionString);
oleDbStringBuilder.Remove("provider");
IBulkCopyWrapper bulkCopyWrapper = null;
switch (conn.Provider)
{
case "sqloledb":
bulkCopyWrapper = new SqlBulkCopyWrapper(new SqlConnection(oleDbStringBuilder.ConnectionString));
break;
case "oraoledb":
bulkCopyWrapper = new OracleBulkCopyWrapper(new OracleConnection(oleDbStringBuilder.ConnectionString));
break;
default: throw new Exception("Not Support OleDbConnection");
}
}
