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 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"));
}