using System; using System.Collections; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.Linq; using System.Reflection; using System.Xml.Linq; class Program { static void Main(string[] args) { XDocument xml = XDocument.Load(@"Employee.xml"); var query = from p in xml.Elements("people").Elements("person") where (int)p.Element("id") == 1 select p; foreach (var record in query) { Console.WriteLine("Employee: {0} {1}", record.Element("firstname").Value, record.Element("lastname").Value); } } }