protected List GetAlbums()

in web-site/Controllers/HomeController.cs [52:72]

• 19 lines of code
• 2 McCabe index (conditional complexity)

        protected List<string> GetAlbums()
        {
            var result = new List<string>();
            var count = 5;

            var connectionString = _configuration.GetConnectionString("Chinook");
            using (var connection = new SqlConnection(connectionString))
            {
                var command = new SqlCommand($"SELECT TOP {count} * FROM dbo.Album ORDER BY NEWID()", connection);
                connection.Open();
                using (var reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        result.Add(reader[1].ToString());
                    }
                }
            }

            return result.ToList();
        }