GenresApiLINQtoXML

 class Program
    {
        static void Main(string[] args)
        {
            Dictionary<int, String> genres = new Dictionary<int, string>();

            Console.WriteLine("begin: " + DateTime.Now);

            var xd = XDocument.Load("fixedAPI.nfpox");
            var query = (from xe in xd.Descendants()
                        from xa in xe.Attributes()
                        where xa.Name == "scheme" && xa.Value.Contains("genre")
                        group xa.NextAttribute by xa into grouping
                        select grouping);
            foreach (IGrouping<XAttribute, XAttribute> entry in query)
            {
                var genreID = Convert.ToInt32(entry.Key.Value.Split('/').Last());
                var genreString = entry.Key.NextAttribute.Value.Split('=').Last();

                if (!genres.ContainsKey(genreID))
                {
                    genres.Add(genreID, genreString);
                }
            }

            foreach (KeyValuePair<int, string> kvp in genres)
            {
                //Console.WriteLine(kvp.Key + " " + kvp.Value);
                using (StreamWriter writer = new StreamWriter("genres.txt", true))
                {
                    writer.WriteLine(kvp.Key + " " + kvp.Value);
                }
            }
        Console.WriteLine("End: " + DateTime.Now);
            Console.ReadKey();

        }
    }
}