private void InsertUsingSqlBatchRunner(IEnumerable<int> ids)
{
var batchRunner = new SqlBatchRunner(TestDb.Connection);
foreach (var id in ids)
InsertOneRecord(batchRunner.RecordingConnection, id);
batchRunner.Run();
}
public void GetSqlStatementTest_ArrayHandling()
{
var ids = Enumerable.Range(1, 3).Select(x => new { id = x });
var batchRunner = new SqlBatchRunner(TestDb.Connection);
batchRunner.RecordingConnection.Execute("select @id", ids);
var sql = batchRunner.GetRecordedSql();
Assert.That(sql, Is.EqualTo("select 1\r\nselect 2\r\nselect 3\r\n"));
}
public void GetSqlStatementTest_IEnumerableHandling()
{
var ids = Enumerable.Range(1, 10);
var batchRunner = new SqlBatchRunner(TestDb.Connection);
batchRunner.RecordingConnection.Execute("select 1 where 1 in (@ids)", new { ids });
var sql = batchRunner.GetRecordedSql();
Assert.That(sql, Is.EqualTo("select 1 where 1 in (('1','2','3','4','5','6','7','8','9','10'))\r\n"));
}
public TempIdTable(IDbConnection conn, IEnumerable <int> ids, string tableName)
{
TableName = tableName;
_conn = conn;
ExecuteNonQuery(conn, "create table " + tableName + " (id int not null)");
var batchRunner = new SqlBatchRunner(conn);
foreach (var id in ids)
{
ExecuteNonQuery(batchRunner.RecordingConnection, "insert into " + tableName + "(id) values(" + id + ")");
}
batchRunner.Run();
}
public TempIdTable(IDbConnection conn, IEnumerable<int> ids, string tableName)
{
TableName = tableName;
_conn = conn;
ExecuteNonQuery(conn, "create table " + tableName + " (id int not null)");
var batchRunner = new SqlBatchRunner(conn);
foreach (var id in ids)
{
ExecuteNonQuery(batchRunner.RecordingConnection, "insert into " + tableName + "(id) values(" + id + ")");
}
batchRunner.Run();
}