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);
}
}
}