public async Task <IActionResult> BulkSelect(int num)
{
using (var db = new AppDb())
{
var time = DateTime.Now;
await db.Connection.OpenAsync();
var query = new BlogPostQuery(db);
var reader = await query.LatestPostsCmd(num).ExecuteReaderAsync();
var numRead = 0;
while (await reader.ReadAsync())
{
var post = new BlogPost(db)
{
Id = await reader.GetFieldValueAsync <int>(0),
Title = await reader.GetFieldValueAsync <string>(1),
Content = await reader.GetFieldValueAsync <string>(2)
};
numRead++;
}
var timing = $"Async: Read {numRead} records in " + (DateTime.Now - time);
Console.WriteLine(timing);
return(new OkObjectResult(timing));
}
}