internal void OdbcBulkInsert(ITableData data, string tableName, BulkInsertSql bulkInsert)
{
string sql = bulkInsert.CreateBulkInsertStatement(data, tableName);
var cmd = DbConnection.CreateCommand();
cmd.Transaction = Transaction as OdbcTransaction;
cmd.Parameters.AddRange(bulkInsert.Parameters.ToArray());
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
public override void BulkInsert(ITableData data, string tableName)
{
BulkInsertSql bulkInsert = new BulkInsertSql()
{
UseParameterQuery = true,
//ConnectionType = ConnectionManagerType.SqlServer
};
OdbcBulkInsert(data, tableName, bulkInsert);
}
public override void BulkInsert(ITableData data, string tableName)
{
BulkInsertSql bulkInsert = new BulkInsertSql()
{
ConnectionType = ConnectionManagerType.Access,
AccessDummyTableName = DummyTableName,
UseParameterQuery = true
};
OdbcBulkInsert(data, tableName, bulkInsert);
}
public override void BulkInsert(ITableData data, string tableName)
{
BulkInsertSql bulkInsert = new BulkInsertSql()
{
UseParameterQuery = true
};
string sql = bulkInsert.CreateBulkInsertStatement(data, tableName);
var cmd = DbConnection.CreateCommand();
cmd.Parameters.AddRange(bulkInsert.Parameters.ToArray());
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
protected override void DoBulkInsert(ITableData data)
{
BulkInsertSql <MySqlParameter> bulkInsert = new BulkInsertSql <MySqlParameter>()
{
UseParameterQuery = true,
ConnectionType = ConnectionManagerType.MySql
};
string sql = bulkInsert.CreateBulkInsertStatement(data, data.Definition.Name);
var cmd = DbConnection.CreateCommand();
cmd.Parameters.AddRange(bulkInsert.Parameters.ToArray());
cmd.CommandText = sql;
cmd.Prepare();
cmd.ExecuteNonQuery();
}
public override void BulkInsert(ITableData data, string tableName)
{
BulkInsertSql <MySqlParameter> bulkInsert = new BulkInsertSql <MySqlParameter>()
{
UseParameterQuery = true,
ConnectionType = ConnectionManagerType.MySql
};
string sql = bulkInsert.CreateBulkInsertStatement(data, tableName);
var cmd = DbConnection.CreateCommand();
cmd.Transaction = Transaction as MySqlTransaction;
cmd.Parameters.AddRange(bulkInsert.Parameters.ToArray());
cmd.CommandText = sql;
cmd.Prepare();
cmd.ExecuteNonQuery();
}
protected override void DoBulkInsert(ITableData data)
{
TryDropDummyTable();
CreateDummyTable();
try
{
BulkInsertSql bulkInsert = new BulkInsertSql()
{
ConnectionType = ConnectionManagerType.Access,
AccessDummyTableName = DummyTableName,
UseParameterQuery = true
};
string sql = bulkInsert.CreateBulkInsertStatement(data, data.Definition.Name);
var cmd = DbConnection.CreateCommand();
cmd.Parameters.AddRange(bulkInsert.Parameters.ToArray());
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
finally
{
TryDropDummyTable();
}
}