private static IEnumerable<IDictionary<string, object>> InsertRowsWithSeparateStatements(AdoAdapter adapter, IEnumerable<IDictionary<string, object>> data,
IDbTransaction transaction, Table table, List<Column> columns,
string insertSql, string selectSql)
{
if (transaction != null)
{
var insertCommand = new CommandHelper(adapter.SchemaProvider).Create(transaction.Connection, insertSql);
var selectCommand = transaction.Connection.CreateCommand();
selectCommand.CommandText = selectSql;
insertCommand.Transaction = transaction;
selectCommand.Transaction = transaction;
return data.Select(row => InsertRow(row, columns, table, insertCommand, selectCommand)).ToList();
}
using (var connection = adapter.CreateConnection())
{
using (var insertCommand = new CommandHelper(adapter.SchemaProvider).Create(connection, insertSql))
using (var selectCommand = connection.CreateCommand())
{
selectCommand.CommandText = selectSql;
connection.Open();
return data.Select(row => InsertRow(row, columns, table, insertCommand, selectCommand)).ToList();
}
}
}
public override IEnumerable<IDictionary<string, object>> InsertRowsWithCompoundStatement(string insertSql, string selectSql)
{
insertSql += "; " + selectSql;
var command = new CommandHelper(Adapter.SchemaProvider).Create(_transaction.Connection, insertSql);
command.Transaction = _transaction;
return Data.Select(row => InsertRowAndSelect(row, command)).ToList();
}
public override IEnumerable<IDictionary<string, object>> InsertRowsWithSeparateStatements(string insertSql, string selectSql, Func<IDictionary<string, object>, Exception, bool> onError)
{
var insertCommand = new CommandHelper(Adapter).Create(_transaction.Connection, insertSql);
var selectCommand = _transaction.Connection.CreateCommand(Adapter.AdoOptions);
selectCommand.CommandText = selectSql;
insertCommand.Transaction = _transaction;
selectCommand.Transaction = _transaction;
return Data.Select(row => InsertRow(row, insertCommand, selectCommand, onError)).ToList();
}
public override IEnumerable<IDictionary<string, object>> InsertRowsWithSeparateStatements(string insertSql, string selectSql)
{
var insertCommand = new CommandHelper(Adapter.SchemaProvider).Create(_transaction.Connection, insertSql);
var selectCommand = _transaction.Connection.CreateCommand();
selectCommand.CommandText = selectSql;
insertCommand.Transaction = _transaction;
selectCommand.Transaction = _transaction;
return Data.Select(row => InsertRow(row, insertCommand, selectCommand)).ToList();
}
public override void InsertRowsWithoutFetchBack(string insertSql, Func<IDictionary<string, object>, Exception, bool> onError)
{
using (var insertCommand = new CommandHelper(Adapter).Create(_transaction.Connection, insertSql))
{
insertCommand.Transaction = _transaction;
foreach (var row in Data)
{
InsertRow(row, insertCommand, onError);
}
}
}
public override void InsertRowsWithoutFetchBack(string insertSql)
{
using (var insertCommand = new CommandHelper(Adapter.SchemaProvider).Create(_transaction.Connection, insertSql))
{
insertCommand.Transaction = _transaction;
foreach (var row in Data)
{
InsertRow(row, insertCommand);
}
}
}
public virtual IEnumerable<IDictionary<string, object>> InsertRowsWithCompoundStatement(string insertSql, string selectSql)
{
insertSql += "; " + selectSql;
using (var connection = Adapter.CreateConnection())
{
using (var command = new CommandHelper(Adapter.SchemaProvider).CreateInsert(connection, insertSql, _columns))
{
connection.Open();
TryPrepare(command);
return Data.Select(row => InsertRowAndSelect(row, command)).ToList();
}
}
}
public virtual IEnumerable<IDictionary<string, object>> InsertRowsWithSeparateStatements(string insertSql, string selectSql)
{
using (var connection = Adapter.CreateConnection())
{
using (var insertCommand = new CommandHelper(Adapter.SchemaProvider).CreateInsert(connection, insertSql, _columns))
using (var selectCommand = connection.CreateCommand())
{
selectCommand.CommandText = selectSql;
connection.Open();
TryPrepare(insertCommand, selectCommand);
return Data.Select(row => InsertRow(row, insertCommand, selectCommand)).ToList();
}
}
}
public virtual IEnumerable<IDictionary<string, object>> InsertRowsWithSeparateStatements(string insertSql, string selectSql, Func<IDictionary<string, object>, Exception, bool> onError)
{
var connection = Adapter.CreateConnection();
using (connection.MaybeDisposable())
{
using (var insertCommand = new CommandHelper(Adapter).CreateInsert(connection, insertSql, _columns))
using (var selectCommand = connection.CreateCommand())
{
selectCommand.CommandText = selectSql;
connection.OpenIfClosed();
TryPrepare(insertCommand, selectCommand);
return Data.Select(row => InsertRow(row, insertCommand, selectCommand, onError)).Where(r => r != null).ToList();
}
}
}
public virtual IEnumerable<IDictionary<string, object>> InsertRowsWithCompoundStatement(string insertSql, string selectSql, Func<IDictionary<string, object>, Exception, bool> onError)
{
insertSql += "; " + selectSql;
var connection = Adapter.CreateConnection();
using (connection.MaybeDisposable())
{
using (var command = new CommandHelper(Adapter).CreateInsert(connection, insertSql, _columns))
{
connection.OpenIfClosed();
TryPrepare(command);
return Data.Select(row => InsertRowAndSelect(row, command, onError)).Where(r => r != null).ToList();
}
}
}
private static void InsertRowsWithoutFetchBack(AdoAdapter adapter, IEnumerable<IDictionary<string, object>> data, Table table, List<Column> columns,
string insertSql)
{
using (var connection = adapter.CreateConnection())
{
using (var insertCommand = new CommandHelper(adapter.SchemaProvider).Create(connection, insertSql))
{
connection.Open();
foreach (var row in data)
{
InsertRow(row, columns, table, insertCommand);
}
}
}
}
public virtual void InsertRowsWithoutFetchBack(string insertSql, Func<IDictionary<string, object>, Exception, bool> onError)
{
var connection = Adapter.CreateConnection();
using (connection.MaybeDisposable())
{
using (var insertCommand = new CommandHelper(Adapter).CreateInsert(connection, insertSql, _columns))
{
connection.OpenIfClosed();
TryPrepare(insertCommand);
foreach (var row in Data)
{
InsertRow(row, insertCommand, onError);
}
}
}
}
public virtual void InsertRowsWithoutFetchBack(string insertSql)
{
using (var connection = Adapter.CreateConnection())
{
using (var insertCommand = new CommandHelper(Adapter.SchemaProvider).CreateInsert(connection, insertSql, _columns))
{
connection.Open();
TryPrepare(insertCommand);
insertCommand.Prepare();
foreach (var row in Data)
{
InsertRow(row, insertCommand);
}
}
}
}
internal IDictionary<string, object> ExecuteSingletonQuery(string sql, params object[] values)
{
if (_transaction != null)
{
var command = new CommandHelper(_adapter.SchemaProvider).Create(_transaction.Connection, sql, values.ToArray());
command.Transaction = _transaction;
return TryExecuteSingletonQuery(command);
}
using (var connection = _adapter.CreateConnection())
{
using (var command = new CommandHelper(_adapter.SchemaProvider).Create(connection, sql, values.ToArray()))
{
connection.Open();
return TryExecuteSingletonQuery(command);
}
}
}
internal IDictionary<string, object> ExecuteSingletonQuery(AdoAdapter adapter, string sql, IEnumerable<Column> columns, IEnumerable<Object> values, IDbTransaction transaction)
{
if (transaction != null)
{
var command = new CommandHelper(adapter).CreateInsert(transaction.Connection, sql, columns, values.ToArray());
command.Transaction = transaction;
return TryExecuteSingletonQuery(command);
}
var connection = adapter.CreateConnection();
using (connection.MaybeDisposable())
{
using (var command = new CommandHelper(adapter).CreateInsert(connection, sql, columns, values.ToArray()))
{
connection.OpenIfClosed();
return TryExecuteSingletonQuery(command);
}
}
}
private static IEnumerable<IDictionary<string, object>> InsertRowsWithCompoundStatement(AdoAdapter adapter, IEnumerable<IDictionary<string, object>> data,
IDbTransaction transaction, Table table, List<Column> columns,
string selectSql, string insertSql)
{
insertSql += "; " + selectSql;
if (transaction != null)
{
var command = new CommandHelper(adapter.SchemaProvider).Create(transaction.Connection, insertSql);
command.Transaction = transaction;
return data.Select(row => InsertRowAndSelect(row, columns, table, command)).ToList();
}
using (var connection = adapter.CreateConnection())
{
using (var command = new CommandHelper(adapter.SchemaProvider).Create(connection, insertSql))
{
connection.Open();
return data.Select(row => InsertRowAndSelect(row, columns, table, command)).ToList();
}
}
}
private IEnumerable<IDictionary<string, object>> ExecuteQuery(string sql, params object[] values)
{
var connection = _connection ?? _adapter.CreateConnection();
var command = new CommandHelper(_adapter).Create(connection, sql, values);
command.Transaction = _transaction;
return TryExecuteQuery(connection, command);
}
public static void SetParameterValue(this IDbCommand command, int index, object value)
{
((IDbDataParameter)command.Parameters[index]).Value = CommandHelper.FixObjectType(value);
}
internal IDictionary<string, object> ExecuteSingletonQuery(string insertSql, string selectSql, params object[] values)
{
if (_transaction != null)
{
var command = new CommandHelper(_adapter).Create(_transaction.Connection, insertSql, values.ToArray());
command.Transaction = _transaction;
TryExecute(command);
command.CommandText = selectSql;
command.Parameters.Clear();
return TryExecuteSingletonQuery(command);
}
using (var connection = _adapter.CreateConnection())
{
using (var command = new CommandHelper(_adapter).Create(connection, insertSql, values.ToArray()))
{
connection.Open();
TryExecute(command);
command.CommandText = selectSql;
command.Parameters.Clear();
return TryExecuteSingletonQuery(command);
}
}
}
internal int Execute(string sql, params object[] values)
{
if (_transaction != null)
{
var command = new CommandHelper(_adapter).Create(_transaction.Connection, sql, values.ToArray());
command.Transaction = _transaction;
return TryExecute(command);
}
using (var connection = _adapter.CreateConnection())
{
using (var command = new CommandHelper(_adapter).Create(connection, sql, values.ToArray()))
{
connection.Open();
return TryExecute(command);
}
}
}
internal int Execute(string sql, IEnumerable<Column> columns, IEnumerable<Object> values)
{
if (_transaction != null)
{
var command = new CommandHelper(_adapter).CreateInsert(_transaction.Connection, sql, columns, values.ToArray());
command.Transaction = _transaction;
return command.TryExecuteNonQuery();
}
var connection = _connection ?? _adapter.CreateConnection();
using (connection.MaybeDisposable())
{
using (var command = new CommandHelper(_adapter).CreateInsert(connection, sql, columns, values.ToArray()))
{
connection.OpenIfClosed();
return command.TryExecuteNonQuery();
}
}
}
internal IDictionary<string, object> ExecuteSingletonQuery(string insertSql, string selectSql, IEnumerable<Column> columns, IEnumerable<Object> values)
{
if (_transaction != null)
{
var command = new CommandHelper(_adapter).CreateInsert(_transaction.Connection, insertSql, columns, values.ToArray());
command.Transaction = _transaction;
command.TryExecuteNonQuery();
command.CommandText = selectSql;
command.Parameters.Clear();
return TryExecuteSingletonQuery(command);
}
var connection = _connection ?? _adapter.CreateConnection();
using (connection.MaybeDisposable())
{
using (var command = new CommandHelper(_adapter).CreateInsert(connection, insertSql, columns, values.ToArray()))
{
connection.OpenIfClosed();
command.TryExecuteNonQuery();
command.CommandText = selectSql;
command.Parameters.Clear();
return TryExecuteSingletonQuery(command);
}
}
}