private static async Task<IReadOnlyList<string>> RetrieveEmployeesAsync(DbConnection connection)
{
var result = new List<string>();
var reader = default(DbDataReader);
try
{
reader = await connection.ExecuteReaderAsync("SELECT [full_name] FROM tc_employee");
while (await reader.ReadAsync())
{
result.Add(reader.GetString(0));
}
}
finally
{
if (reader != null) reader.Dispose();
}
return result;
}