---

// 3. АСИКРОННОЕ ЧТЕНИЕ АВТОРОВ

await Task.Run(LoadAuthorsAsync());

string connectionString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Lakrazy;Integrated Security=True;";
string sql = "SELECT Id, FirstName, LastName FROM Authors";

using (SqlConnection conn = new SqlConnection(connectionString))
{
    await conn.OpenAsync();

    using (SqlCommand cmd = new SqlCommand(sql, conn))
    using (SqlDataReader reader = await cmd.ExecuteReaderAsync())
    {
        while (await reader.ReadAsync())
        {
            int id = reader.GetInt32(0);
            string firstName = reader.GetString(1);
            string lastName = reader.GetString(2);

            Console.WriteLine($"{id}. {firstName} {lastName}");
        }
    }
}