using System;

using System.Linq;

using System.Xml.Linq;

using System.Collections;

public class Program

{

    public static void Main()

    {

           XElement xelGOT =

              new XElement("GameOfThrones",

                 new XElement("Characters",

                     new XElement("Character",

                         new XAttribute("Status", "deceased"),

                         new XElement("Name", "Daenerys Targaryen"),

                         new XElement("Actor", "Emilia Clarke")

                         ),

                     new XElement("Character",

                         new XAttribute("Status", "living"),

                         new XElement("Name", "Jon Snow"),

                         new XElement("Actor", "Kit Harrington")

                         ),

                     new XElement("Character",

                         new XAttribute("Status", "living"),

                         new XElement("Name", "Tyrion Lannister"),

                         new XElement("Actor", "Peter Dinklage")

                         )

                      )

                );

            // This one works (except for the "orderby") 

            string secondLivingCharacter =

                (from xchar in xelGOT.Elements("Characters").First().Elements("Character")

                 where (string)xchar.Attribute("Status").Value == "living"

                 //orderby xchar.Element("Name")

                 select xchar).ElementAt(1).Value;

            Console.WriteLine("secondLivingCharacter=" + secondLivingCharacter); 

            // Get all the living characters 

            IEnumerable results =   

                (from xchar in xelGOT.Elements("Characters").First().Elements("Character")

                where (string) xchar.Attribute("Status").Value == "living"

                select xchar).Elements();

​

            foreach (var result in results.Cast<XElement>())

            {

                Console.WriteLine("\n\nDebug result=" + result.ToString()); 

                Console.WriteLine(

                          " Character=" + result.Element("Name").Value +

                          " Actor=" + result.Element("Actor").Value +

                          " Status=" + result.Attribute("Status")

                     );

            }

​

​

​

    }

}