public async System.Threading.Tasks.Task CheckAsyncIEnumerable()
{
await using var sw = new MsSqlWorker(ConnectionString);
await using var tran = await sw.TransactionBeginAsync();
var n = 1;
await foreach (var x in sw.QueryAsync(
@"select number, square, sqrt, is_prime from dbo.numbers n",
dr => new {
number = (int)dr[0],
square = (long)dr[1],
sqrt = (double)dr[2],
is_prime = (bool)dr[3],
},
transaction: tran
))
{
Assert.AreEqual(x.number, n);
++n;
}
}
